datos_liga
Enrique Roa, Miguel Ocón, Sergio Fernández
08 de enero de 2023
1 INTRODUCCIÓN Y DEFINICIÓN DE OBJETIVOS
En este proyecto vamos a estudiar el dataset llamado “combined_data_laliga.csv” donde se encuentran todos los partidos de la temporada 2014 hasta la temporada 2020, ambas incluidas, con una recopilación de los principales eventos que ocurren en un partido, goles, tiros a puerta, faltas, tarjetas…
- ¿Qué hace que un equipo gane un partido?
- ¿Qué variables influyen en las victorias?
- ¿Es posible predecir el ganador de un partido?
Para dar respuesta a todas estas preguntas estos han sido los pasos que hemos ido dando en nuestro estudio:
- Lectura y exploración inicial
- Limpieza de datos
- Trasformación de variables
- División del dataset en train (2014 - 2019) y test (2020)
- EDA
- Regresión
1.1 LIBRERÍAS UTILIZADAS
library(dplyr)
library(tidyr)
library(knitr)
library(readr)
library(ggplot2)
library(cowplot)
library(GGally)
library(plotrix)
1.2 LECTURA DE DATOS
laliga <- read_csv("combined_data_laliga.csv")
2 ANÁLISIS EXPLORATORIO INICIAL
Exploración inicial de datos a través de estadísticos principales
str(laliga)## spc_tbl_ [2,660 × 41] (S3: spec_tbl_df/tbl_df/tbl/data.frame)
## $ ...1 : num [1:2660] 0 1 2 3 4 5 6 7 8 9 ...
## $ Home Team : chr [1:2660] "MÁLAGA" "SEVILLA FC" "GRANADA" "ALMERÍA" ...
## $ Away Team : chr [1:2660] "ATHLETIC" "VALENCIA" "DEPORTIVO" "ESPANYOL" ...
## $ Score : chr [1:2660] "1-0" "1-1" "2-1" "1-1" ...
## $ Half Time Score : chr [1:2660] "1-0" "1-0" "0-1" "0-0" ...
## $ Match Excitement : num [1:2660] 4.4 4.7 4.6 5.6 3.7 5.1 7 4.7 4.7 2.1 ...
## $ Home Team Rating : num [1:2660] 6 6.5 7.2 6.9 6.5 8 7.3 5.6 6.9 6.9 ...
## $ Away Team Rating : num [1:2660] 5.7 6.8 5.9 5.5 5.9 5.3 5.5 7.3 5.5 5.9 ...
## $ Home Team Possession % : num [1:2660] 40 47 53 56 41 72 59 53 63 59 ...
## $ Away Team Possession % : num [1:2660] 60 53 47 44 59 28 41 47 37 41 ...
## $ Home Team Off Target Shots : num [1:2660] 5 4 6 7 5 5 4 4 3 5 ...
## $ Home Team On Target Shots : num [1:2660] 3 3 3 6 5 6 9 2 8 2 ...
## $ Home Team Total Shots : num [1:2660] 12 12 10 19 12 12 20 9 14 8 ...
## $ Home Team Blocked Shots : num [1:2660] 4 5 1 6 2 1 7 3 3 1 ...
## $ Home Team Corners : num [1:2660] 5 3 5 11 5 3 4 3 8 2 ...
## $ Home Team Throw Ins : num [1:2660] 13 20 25 26 28 23 21 16 25 23 ...
## $ Home Team Pass Success % : num [1:2660] 69 76 79 81 60 93 82 80 88 79 ...
## $ Home Team Aerials Won : num [1:2660] 11 13 20 19 29 2 27 19 23 21 ...
## $ Home Team Clearances : num [1:2660] 16 16 21 25 17 2 15 12 13 20 ...
## $ Home Team Fouls : num [1:2660] 13 23 13 8 13 11 19 11 9 13 ...
## $ Home Team Yellow Cards : num [1:2660] 3 4 1 3 4 0 4 1 1 2 ...
## $ Home Team Second Yellow Cards: num [1:2660] 0 0 0 0 0 0 0 0 0 0 ...
## $ Home Team Red Cards : num [1:2660] 2 0 0 0 0 1 0 0 0 0 ...
## $ Away Team Off Target Shots : num [1:2660] 5 5 1 6 7 3 8 5 6 3 ...
## $ Away Team On Target Shots : num [1:2660] 5 1 1 2 4 0 3 6 2 2 ...
## $ Away Team Total Shots : num [1:2660] 12 11 8 12 19 3 12 12 8 9 ...
## $ Away Team Blocked Shots : num [1:2660] 2 5 6 4 8 0 1 1 0 4 ...
## $ Away Team Corners : num [1:2660] 4 3 3 7 6 1 4 4 5 4 ...
## $ Away Team Throw Ins : num [1:2660] 22 27 30 19 36 19 19 14 18 34 ...
## $ Away Team Pass Success % : num [1:2660] 84 79 76 70 75 81 74 78 79 68 ...
## $ Away Team Aerials Won : num [1:2660] 17 14 10 11 25 4 22 21 15 26 ...
## $ Away Team Clearances : num [1:2660] 14 16 14 20 20 17 7 18 27 15 ...
## $ Away Team Fouls : num [1:2660] 9 8 26 9 14 13 15 14 13 17 ...
## $ Away Team Yellow Cards : num [1:2660] 3 2 3 3 1 1 1 3 2 2 ...
## $ Away Team Second Yellow Cards: num [1:2660] 0 0 0 1 0 0 0 0 0 0 ...
## $ Away Team Red Cards : num [1:2660] 0 1 0 0 0 0 0 0 0 0 ...
## $ Home Team Goals Scored : num [1:2660] 1 1 2 1 1 3 3 0 2 0 ...
## $ Away Team Goals Scored : num [1:2660] 0 1 1 1 0 0 1 2 0 0 ...
## $ Home Team Goals Conceeded : num [1:2660] 0 1 1 1 0 0 1 2 0 0 ...
## $ Away Team Goals Conceeded : num [1:2660] 1 1 2 1 1 3 3 0 2 0 ...
## $ year : num [1:2660] 2014 2014 2014 2014 2014 ...
## - attr(*, "spec")=
## .. cols(
## .. ...1 = col_double(),
## .. `Home Team` = col_character(),
## .. `Away Team` = col_character(),
## .. Score = col_character(),
## .. `Half Time Score` = col_character(),
## .. `Match Excitement` = col_double(),
## .. `Home Team Rating` = col_double(),
## .. `Away Team Rating` = col_double(),
## .. `Home Team Possession %` = col_double(),
## .. `Away Team Possession %` = col_double(),
## .. `Home Team Off Target Shots` = col_double(),
## .. `Home Team On Target Shots` = col_double(),
## .. `Home Team Total Shots` = col_double(),
## .. `Home Team Blocked Shots` = col_double(),
## .. `Home Team Corners` = col_double(),
## .. `Home Team Throw Ins` = col_double(),
## .. `Home Team Pass Success %` = col_double(),
## .. `Home Team Aerials Won` = col_double(),
## .. `Home Team Clearances` = col_double(),
## .. `Home Team Fouls` = col_double(),
## .. `Home Team Yellow Cards` = col_double(),
## .. `Home Team Second Yellow Cards` = col_double(),
## .. `Home Team Red Cards` = col_double(),
## .. `Away Team Off Target Shots` = col_double(),
## .. `Away Team On Target Shots` = col_double(),
## .. `Away Team Total Shots` = col_double(),
## .. `Away Team Blocked Shots` = col_double(),
## .. `Away Team Corners` = col_double(),
## .. `Away Team Throw Ins` = col_double(),
## .. `Away Team Pass Success %` = col_double(),
## .. `Away Team Aerials Won` = col_double(),
## .. `Away Team Clearances` = col_double(),
## .. `Away Team Fouls` = col_double(),
## .. `Away Team Yellow Cards` = col_double(),
## .. `Away Team Second Yellow Cards` = col_double(),
## .. `Away Team Red Cards` = col_double(),
## .. `Home Team Goals Scored` = col_double(),
## .. `Away Team Goals Scored` = col_double(),
## .. `Home Team Goals Conceeded` = col_double(),
## .. `Away Team Goals Conceeded` = col_double(),
## .. year = col_double()
## .. )
## - attr(*, "problems")=<externalptr>
summary(laliga) ## ...1 Home Team Away Team Score
## Min. : 0.0 Length:2660 Length:2660 Length:2660
## 1st Qu.: 664.8 Class :character Class :character Class :character
## Median :1329.5 Mode :character Mode :character Mode :character
## Mean :1329.5
## 3rd Qu.:1994.2
## Max. :2659.0
## Half Time Score Match Excitement Home Team Rating Away Team Rating
## Length:2660 Min. : 1.400 Min. : 2.800 Min. : 3.000
## Class :character 1st Qu.: 3.900 1st Qu.: 5.700 1st Qu.: 5.400
## Mode :character Median : 5.100 Median : 6.400 Median : 6.000
## Mean : 5.249 Mean : 6.369 Mean : 6.045
## 3rd Qu.: 6.300 3rd Qu.: 6.900 3rd Qu.: 6.600
## Max. :10.000 Max. :10.000 Max. :10.000
## Home Team Possession % Away Team Possession % Home Team Off Target Shots
## Min. :18.00 Min. :17.00 Min. : 0.000
## 1st Qu.:44.00 1st Qu.:41.00 1st Qu.: 4.000
## Median :52.00 Median :48.00 Median : 5.000
## Mean :51.54 Mean :48.46 Mean : 5.533
## 3rd Qu.:59.00 3rd Qu.:56.00 3rd Qu.: 7.000
## Max. :83.00 Max. :82.00 Max. :18.000
## Home Team On Target Shots Home Team Total Shots Home Team Blocked Shots
## Min. : 0.000 Min. : 2.00 Min. : 0.000
## 1st Qu.: 3.000 1st Qu.:10.00 1st Qu.: 1.000
## Median : 4.000 Median :13.00 Median : 3.000
## Mean : 4.648 Mean :13.08 Mean : 2.913
## 3rd Qu.: 6.000 3rd Qu.:16.00 3rd Qu.: 4.000
## Max. :17.000 Max. :33.00 Max. :12.000
## Home Team Corners Home Team Throw Ins Home Team Pass Success %
## Min. : 0.000 Min. : 5.0 Min. :46.00
## 1st Qu.: 3.000 1st Qu.:18.0 1st Qu.:73.00
## Median : 5.000 Median :22.0 Median :78.00
## Mean : 5.395 Mean :22.5 Mean :77.71
## 3rd Qu.: 7.000 3rd Qu.:27.0 3rd Qu.:84.00
## Max. :20.000 Max. :49.0 Max. :93.00
## Home Team Aerials Won Home Team Clearances Home Team Fouls
## Min. : 2.0 Min. : 1.00 Min. : 1.00
## 1st Qu.:12.0 1st Qu.:12.00 1st Qu.:11.00
## Median :16.0 Median :17.00 Median :14.00
## Mean :17.1 Mean :17.71 Mean :13.75
## 3rd Qu.:22.0 3rd Qu.:22.00 3rd Qu.:16.00
## Max. :52.0 Max. :61.00 Max. :33.00
## Home Team Yellow Cards Home Team Second Yellow Cards Home Team Red Cards
## Min. :0.000 Min. :0.00000 Min. :0.00000
## 1st Qu.:1.000 1st Qu.:0.00000 1st Qu.:0.00000
## Median :2.000 Median :0.00000 Median :0.00000
## Mean :2.417 Mean :0.05602 Mean :0.04699
## 3rd Qu.:3.000 3rd Qu.:0.00000 3rd Qu.:0.00000
## Max. :8.000 Max. :2.00000 Max. :2.00000
## Away Team Off Target Shots Away Team On Target Shots Away Team Total Shots
## Min. : 0.00 Min. : 0.000 Min. : 0.00
## 1st Qu.: 3.00 1st Qu.: 2.000 1st Qu.: 7.00
## Median : 4.00 Median : 3.000 Median :10.00
## Mean : 4.32 Mean : 3.669 Mean :10.36
## 3rd Qu.: 6.00 3rd Qu.: 5.000 3rd Qu.:13.00
## Max. :14.00 Max. :13.000 Max. :28.00
## Away Team Blocked Shots Away Team Corners Away Team Throw Ins
## Min. : 0.000 Min. : 0.000 Min. : 3.00
## 1st Qu.: 1.000 1st Qu.: 2.000 1st Qu.:17.00
## Median : 2.000 Median : 4.000 Median :21.00
## Mean : 2.391 Mean : 4.215 Mean :21.48
## 3rd Qu.: 3.000 3rd Qu.: 6.000 3rd Qu.:26.00
## Max. :13.000 Max. :32.000 Max. :45.00
## Away Team Pass Success % Away Team Aerials Won Away Team Clearances
## Min. :41.0 Min. : 0.00 Min. : 1.00
## 1st Qu.:71.0 1st Qu.:11.00 1st Qu.:14.00
## Median :77.0 Median :16.00 Median :20.00
## Mean :75.9 Mean :16.75 Mean :21.43
## 3rd Qu.:82.0 3rd Qu.:21.00 3rd Qu.:27.00
## Max. :93.0 Max. :53.00 Max. :63.00
## Away Team Fouls Away Team Yellow Cards Away Team Second Yellow Cards
## Min. : 0.00 Min. :0.000 Min. :0.00000
## 1st Qu.:11.00 1st Qu.:2.000 1st Qu.:0.00000
## Median :13.00 Median :3.000 Median :0.00000
## Mean :13.77 Mean :2.641 Mean :0.07744
## 3rd Qu.:16.00 3rd Qu.:4.000 3rd Qu.:0.00000
## Max. :30.00 Max. :8.000 Max. :2.00000
## Away Team Red Cards Home Team Goals Scored Away Team Goals Scored
## Min. :0.00000 Min. : 0.000 Min. :0.000
## 1st Qu.:0.00000 1st Qu.: 1.000 1st Qu.:0.000
## Median :0.00000 Median : 1.000 Median :1.000
## Mean :0.04887 Mean : 1.518 Mean :1.141
## 3rd Qu.:0.00000 3rd Qu.: 2.000 3rd Qu.:2.000
## Max. :2.00000 Max. :10.000 Max. :8.000
## Home Team Goals Conceeded Away Team Goals Conceeded year
## Min. :0.000 Min. : 0.000 Min. :2014
## 1st Qu.:0.000 1st Qu.: 1.000 1st Qu.:2015
## Median :1.000 Median : 1.000 Median :2017
## Mean :1.141 Mean : 1.518 Mean :2017
## 3rd Qu.:2.000 3rd Qu.: 2.000 3rd Qu.:2019
## Max. :8.000 Max. :10.000 Max. :2020
El dataframe contiene todos los partidos de la liga española de 7
temporadas (de 2014 a 2020).
- 2660 observaciones (partidos)
- 40 variables
- 4 variables cualitativas (dos de tipo texto)
- 36 variables cuantitativas discretas
- No hay valores faltantes
Home Team: Equipo local
Away Team: Equipo visitante
Score: Resultado (ejemplo 2-1)
Half Time Score: Resultado al descanso (ejemplo
1-1)
Match Excitement: Emoción del partido (subjetiva)
Home Team Rating: Nota del local (subjetiva)
Away Team Rating: Nota del visitante (subjetiva)
Home Team Possession: Posesión local
Away Team Possession: Posesión visitante
Home Team off Target Shots: Tiros fuera local
Home Team on Target Shots: Tiros a puerta local
Home Team Total Shots: Total tiros local
Home Team Blocked Shots: Tiros bloqueados local
Home Team Corners: Corners local
Home Team Throw Ins: Centros local
Home Team Pass Success: Pases exitosos local
Home Team Aerials Won: Balones aereos ganados
local
Home Team Clearances: Despejes local
Home Team Fouls: Faltas local
Home Team Yellow Cards: Amarillas local
Home Team Second Yellow Cards: Segundas amarillas
local
Home Team Red Cards: Rojas local
Away Team off Target Shots: Tiros fuera visitante
Away Team on Target Shots: Tiros a puerta
visitante
Away Team Total Shots: Total tiros visitante
Away Team Blocked Shots: Tiros bloqueados
visitante
Away Team Corners: Corners visitante
Away Team Throw Ins: Centros visitante
Away Team Pass Success: Pases exitosos visitante
Away Team Aerials Won: Balones aereos ganados
visitante
Away Team Clearances: Despejes visitante
Away Team Fouls: Faltas visitante
Away Team Yellow Cards: Amarillas visitante
Away Team Second Yellow Cards: Segundas amarillas
visitante
Away Team Red Cards: Rojas visitante
Home Team Goals Scored: Goles local
Away Team Goals Scored: Goles visitante
Home Team Goals Conceeded: Goles visitante
Away Team Goals Conceeded: Goles local
Year: Año
3 LIMPIEZA Y CREACIÓN
3.1 LIMPIEZA DE DATOS
Limpieza de datos en columnas quitando los espacios y cambiandolos por guiones ya que los espacios dan bastantes problemas a la hora de llamar a las variables.
names(laliga) <- gsub(" ","_", names(laliga))Limpieza de variables que no nos interesa estudiar
laliga$Score <- NULL
laliga$`Half_Time_Score` <- NULL
laliga$`Match_Excitement` <- NULL
laliga$`Home_Team_Rating` <- NULL
laliga$`Away_Team_Rating` <- NULL
laliga$`Home_Team_Goals_Conceeded` <- NULL
laliga$`Away_Team_Goals_Conceeded` <- NULL
3.2 CREACIÓN DE NUEVAS VARIABLES
Creación de campos que interesa estudiar más adelante
laliga <- mutate(laliga, score = ifelse(Home_Team_Goals_Scored-Away_Team_Goals_Scored > 0, "1",
ifelse(Home_Team_Goals_Scored-Away_Team_Goals_Scored < 0, "2", "x")))
laliga <- mutate(laliga, goals = Home_Team_Goals_Scored + Away_Team_Goals_Scored)
laliga <- mutate(laliga, home_points = case_when(score == 1 ~ 3,
score == "x" ~ 1,
score == 2 ~ 0))
laliga <- mutate(laliga, away_points = case_when(score == 1 ~ 0,
score == "x" ~ 1,
score == 2 ~ 3))
laliga <- mutate(laliga, jornada = ceiling(row_number() / 10)) %>%
mutate(jornada = (jornada - 1) %% 38 + 1)
Creación de campos que se quieren estudiar conforme avance el proyecto.
laliga <- mutate(laliga, total_off_target_shots = Home_Team_Off_Target_Shots + Away_Team_Off_Target_Shots)
laliga <- mutate(laliga, total_on_target_shots = Home_Team_On_Target_Shots + Away_Team_On_Target_Shots)
laliga <- mutate(laliga, total_shots = Home_Team_Total_Shots + Away_Team_Total_Shots)
laliga <- mutate(laliga, total_blocked_shots = Home_Team_Blocked_Shots + Away_Team_Blocked_Shots)
laliga <- mutate(laliga, total_corners = Home_Team_Corners + Away_Team_Corners)
laliga <- mutate(laliga, total_throw_ins = Home_Team_Throw_Ins + Away_Team_Throw_Ins)
laliga <- mutate(laliga, total_pass_success = `Home_Team_Pass_Success_%` + `Away_Team_Pass_Success_%`)
laliga <- mutate(laliga, total_aerials_won = Home_Team_Aerials_Won + Away_Team_Aerials_Won)
laliga <- mutate(laliga, total_clearances = Home_Team_Clearances + Away_Team_Clearances)
laliga <- mutate(laliga, total_fouls = Home_Team_Fouls + Away_Team_Fouls)
laliga <- mutate(laliga, total_yellow_cards = Home_Team_Yellow_Cards + Away_Team_Yellow_Cards)
laliga <- mutate(laliga, total_second_yellow_cards = Home_Team_Second_Yellow_Cards + Away_Team_Second_Yellow_Cards)
laliga <- mutate(laliga, total_red_cards = Home_Team_Red_Cards + Away_Team_Red_Cards)
3.3 CONVERSIÓN DE VARIABLES
Convertimos determinadas variables a categorías.
laliga$Home_Team <- as.factor(laliga$Home_Team)
laliga$Away_Team <- as.factor(laliga$Away_Team)
laliga$score <- factor(laliga$score, levels = c("1", "x", "2"))
3.4 DIVISIÓN TRAIN - TEST
Dividimos el dataset original en train y test. Decidimos que train contenga 6 de las 7 temporadas para utilizar los partidos de la 7ª (temp. 2020) en la fase de test.
test <- filter(laliga, year==2020)
train <- filter(laliga, year<2020)
#write.csv(test,"test/test_laliga.csv")
#write.csv(train,"train/train_laliga.csv")
3.5 CREACIÓN DE DATASETS ÚTILES
Creación de dataset útiles para diversos análisis y comparativas. Dataframes separados por tipo de resultado “score”.
Victorias_casa <- train %>% filter(score==1)
Derrotas_casa <- train %>% filter(score==2)
Empates <- train %>% filter(score=="x")
3.6 RESUMEN FINAL DE VARIABLES
str(train)## tibble [2,280 × 52] (S3: tbl_df/tbl/data.frame)
## $ ...1 : num [1:2280] 0 1 2 3 4 5 6 7 8 9 ...
## $ Home_Team : Factor w/ 31 levels "ALAVÉS","ALMERÍA",..: 21 28 16 2 10 5 7 20 26 24 ...
## $ Away_Team : Factor w/ 31 levels "ALAVÉS","ALMERÍA",..: 3 29 9 12 27 11 13 31 8 4 ...
## $ Home_Team_Possession_% : num [1:2280] 40 47 53 56 41 72 59 53 63 59 ...
## $ Away_Team_Possession_% : num [1:2280] 60 53 47 44 59 28 41 47 37 41 ...
## $ Home_Team_Off_Target_Shots : num [1:2280] 5 4 6 7 5 5 4 4 3 5 ...
## $ Home_Team_On_Target_Shots : num [1:2280] 3 3 3 6 5 6 9 2 8 2 ...
## $ Home_Team_Total_Shots : num [1:2280] 12 12 10 19 12 12 20 9 14 8 ...
## $ Home_Team_Blocked_Shots : num [1:2280] 4 5 1 6 2 1 7 3 3 1 ...
## $ Home_Team_Corners : num [1:2280] 5 3 5 11 5 3 4 3 8 2 ...
## $ Home_Team_Throw_Ins : num [1:2280] 13 20 25 26 28 23 21 16 25 23 ...
## $ Home_Team_Pass_Success_% : num [1:2280] 69 76 79 81 60 93 82 80 88 79 ...
## $ Home_Team_Aerials_Won : num [1:2280] 11 13 20 19 29 2 27 19 23 21 ...
## $ Home_Team_Clearances : num [1:2280] 16 16 21 25 17 2 15 12 13 20 ...
## $ Home_Team_Fouls : num [1:2280] 13 23 13 8 13 11 19 11 9 13 ...
## $ Home_Team_Yellow_Cards : num [1:2280] 3 4 1 3 4 0 4 1 1 2 ...
## $ Home_Team_Second_Yellow_Cards: num [1:2280] 0 0 0 0 0 0 0 0 0 0 ...
## $ Home_Team_Red_Cards : num [1:2280] 2 0 0 0 0 1 0 0 0 0 ...
## $ Away_Team_Off_Target_Shots : num [1:2280] 5 5 1 6 7 3 8 5 6 3 ...
## $ Away_Team_On_Target_Shots : num [1:2280] 5 1 1 2 4 0 3 6 2 2 ...
## $ Away_Team_Total_Shots : num [1:2280] 12 11 8 12 19 3 12 12 8 9 ...
## $ Away_Team_Blocked_Shots : num [1:2280] 2 5 6 4 8 0 1 1 0 4 ...
## $ Away_Team_Corners : num [1:2280] 4 3 3 7 6 1 4 4 5 4 ...
## $ Away_Team_Throw_Ins : num [1:2280] 22 27 30 19 36 19 19 14 18 34 ...
## $ Away_Team_Pass_Success_% : num [1:2280] 84 79 76 70 75 81 74 78 79 68 ...
## $ Away_Team_Aerials_Won : num [1:2280] 17 14 10 11 25 4 22 21 15 26 ...
## $ Away_Team_Clearances : num [1:2280] 14 16 14 20 20 17 7 18 27 15 ...
## $ Away_Team_Fouls : num [1:2280] 9 8 26 9 14 13 15 14 13 17 ...
## $ Away_Team_Yellow_Cards : num [1:2280] 3 2 3 3 1 1 1 3 2 2 ...
## $ Away_Team_Second_Yellow_Cards: num [1:2280] 0 0 0 1 0 0 0 0 0 0 ...
## $ Away_Team_Red_Cards : num [1:2280] 0 1 0 0 0 0 0 0 0 0 ...
## $ Home_Team_Goals_Scored : num [1:2280] 1 1 2 1 1 3 3 0 2 0 ...
## $ Away_Team_Goals_Scored : num [1:2280] 0 1 1 1 0 0 1 2 0 0 ...
## $ year : num [1:2280] 2014 2014 2014 2014 2014 ...
## $ score : Factor w/ 3 levels "1","x","2": 1 2 1 2 1 1 1 3 1 2 ...
## $ goals : num [1:2280] 1 2 3 2 1 3 4 2 2 0 ...
## $ home_points : num [1:2280] 3 1 3 1 3 3 3 0 3 1 ...
## $ away_points : num [1:2280] 0 1 0 1 0 0 0 3 0 1 ...
## $ jornada : num [1:2280] 1 1 1 1 1 1 1 1 1 1 ...
## $ total_off_target_shots : num [1:2280] 10 9 7 13 12 8 12 9 9 8 ...
## $ total_on_target_shots : num [1:2280] 8 4 4 8 9 6 12 8 10 4 ...
## $ total_shots : num [1:2280] 24 23 18 31 31 15 32 21 22 17 ...
## $ total_blocked_shots : num [1:2280] 6 10 7 10 10 1 8 4 3 5 ...
## $ total_corners : num [1:2280] 9 6 8 18 11 4 8 7 13 6 ...
## $ total_throw_ins : num [1:2280] 35 47 55 45 64 42 40 30 43 57 ...
## $ total_pass_success : num [1:2280] 153 155 155 151 135 174 156 158 167 147 ...
## $ total_aerials_won : num [1:2280] 28 27 30 30 54 6 49 40 38 47 ...
## $ total_clearances : num [1:2280] 30 32 35 45 37 19 22 30 40 35 ...
## $ total_fouls : num [1:2280] 22 31 39 17 27 24 34 25 22 30 ...
## $ total_yellow_cards : num [1:2280] 6 6 4 6 5 1 5 4 3 4 ...
## $ total_second_yellow_cards : num [1:2280] 0 0 0 1 0 0 0 0 0 0 ...
## $ total_red_cards : num [1:2280] 2 1 0 0 0 1 0 0 0 0 ...
Las nuevas variables creadas son las siguientes:
- score: resultado 1 X 2
- goals: total goles del partido
- home_points: puntos del equipo local
- away_points: de tipo categórico
- jornada: nº de jornada liguera
- total_off_target_shots: total disparos NO a puerta
- total_on_target_shots: total disparos a puerta
- total_shots: total disparos
- total_blocked_shots: total disparos bloqueados
- total_corners: corners totales
- total_throw_ins: total centros al área
- total_pass_success: pases totales con éxito
- total_aerials_won: balones aéreos ganados totales
- total_clearances: despejes totales
- total_fouls: faltas totales
- total_yellow_cards: tarjetas amarillas totales
- total_second_yellow_cards: segundas tarjetas amarillas totales
- total_red_cards: tarjetas rojas totales
summary(train)## ...1 Home_Team Away_Team
## Min. : 0.0 ATHLETIC : 114 ATHLETIC : 114
## 1st Qu.: 569.8 ATLETICO MADRID: 114 ATLETICO MADRID: 114
## Median :1139.5 BARCELONA : 114 BARCELONA : 114
## Mean :1139.5 CELTA : 114 CELTA : 114
## 3rd Qu.:1709.2 EIBAR : 114 EIBAR : 114
## Max. :2279.0 ESPANYOL : 114 ESPANYOL : 114
## (Other) :1596 (Other) :1596
## Home_Team_Possession_% Away_Team_Possession_% Home_Team_Off_Target_Shots
## Min. :19.00 Min. :17.00 Min. : 0.000
## 1st Qu.:44.00 1st Qu.:41.00 1st Qu.: 4.000
## Median :52.00 Median :48.00 Median : 5.000
## Mean :51.68 Mean :48.32 Mean : 5.635
## 3rd Qu.:59.00 3rd Qu.:56.00 3rd Qu.: 7.000
## Max. :83.00 Max. :81.00 Max. :18.000
##
## Home_Team_On_Target_Shots Home_Team_Total_Shots Home_Team_Blocked_Shots
## Min. : 0.000 Min. : 2.00 Min. : 0.000
## 1st Qu.: 3.000 1st Qu.:10.00 1st Qu.: 2.000
## Median : 4.000 Median :13.00 Median : 3.000
## Mean : 4.757 Mean :13.36 Mean : 2.978
## 3rd Qu.: 6.000 3rd Qu.:16.00 3rd Qu.: 4.000
## Max. :17.000 Max. :33.00 Max. :12.000
##
## Home_Team_Corners Home_Team_Throw_Ins Home_Team_Pass_Success_%
## Min. : 0.000 Min. : 5.00 Min. :46.00
## 1st Qu.: 3.000 1st Qu.:18.00 1st Qu.:73.00
## Median : 5.000 Median :22.00 Median :78.00
## Mean : 5.556 Mean :22.76 Mean :77.64
## 3rd Qu.: 7.000 3rd Qu.:27.00 3rd Qu.:83.00
## Max. :20.000 Max. :49.00 Max. :93.00
##
## Home_Team_Aerials_Won Home_Team_Clearances Home_Team_Fouls
## Min. : 2.00 Min. : 1.00 Min. : 1.00
## 1st Qu.:12.00 1st Qu.:12.00 1st Qu.:11.00
## Median :16.00 Median :17.00 Median :14.00
## Mean :17.12 Mean :18.01 Mean :13.82
## 3rd Qu.:22.00 3rd Qu.:23.00 3rd Qu.:17.00
## Max. :50.00 Max. :61.00 Max. :33.00
##
## Home_Team_Yellow_Cards Home_Team_Second_Yellow_Cards Home_Team_Red_Cards
## Min. :0.000 Min. :0.00000 Min. :0.00000
## 1st Qu.:1.000 1st Qu.:0.00000 1st Qu.:0.00000
## Median :2.000 Median :0.00000 Median :0.00000
## Mean :2.465 Mean :0.05833 Mean :0.04561
## 3rd Qu.:3.000 3rd Qu.:0.00000 3rd Qu.:0.00000
## Max. :8.000 Max. :2.00000 Max. :2.00000
##
## Away_Team_Off_Target_Shots Away_Team_On_Target_Shots Away_Team_Total_Shots
## Min. : 0.000 Min. : 0.000 Min. : 0.00
## 1st Qu.: 3.000 1st Qu.: 2.000 1st Qu.: 7.00
## Median : 4.000 Median : 3.000 Median :10.00
## Mean : 4.336 Mean : 3.708 Mean :10.43
## 3rd Qu.: 6.000 3rd Qu.: 5.000 3rd Qu.:13.00
## Max. :14.000 Max. :13.000 Max. :28.00
##
## Away_Team_Blocked_Shots Away_Team_Corners Away_Team_Throw_Ins
## Min. : 0.000 Min. : 0.000 Min. : 3.00
## 1st Qu.: 1.000 1st Qu.: 2.000 1st Qu.:17.00
## Median : 2.000 Median : 4.000 Median :21.00
## Mean : 2.408 Mean : 4.202 Mean :21.59
## 3rd Qu.: 3.000 3rd Qu.: 6.000 3rd Qu.:26.00
## Max. :11.000 Max. :32.000 Max. :45.00
##
## Away_Team_Pass_Success_% Away_Team_Aerials_Won Away_Team_Clearances
## Min. :41.0 Min. : 0.00 Min. : 2.00
## 1st Qu.:71.0 1st Qu.:11.00 1st Qu.:15.00
## Median :77.0 Median :16.00 Median :21.00
## Mean :75.7 Mean :16.68 Mean :22.21
## 3rd Qu.:82.0 3rd Qu.:21.00 3rd Qu.:28.00
## Max. :93.0 Max. :53.00 Max. :63.00
##
## Away_Team_Fouls Away_Team_Yellow_Cards Away_Team_Second_Yellow_Cards
## Min. : 0.00 Min. :0.000 Min. :0.00000
## 1st Qu.:11.00 1st Qu.:2.000 1st Qu.:0.00000
## Median :14.00 Median :3.000 Median :0.00000
## Mean :13.86 Mean :2.707 Mean :0.08202
## 3rd Qu.:17.00 3rd Qu.:4.000 3rd Qu.:0.00000
## Max. :30.00 Max. :8.000 Max. :2.00000
##
## Away_Team_Red_Cards Home_Team_Goals_Scored Away_Team_Goals_Scored
## Min. :0.00000 Min. : 0.000 Min. :0.000
## 1st Qu.:0.00000 1st Qu.: 1.000 1st Qu.:0.000
## Median :0.00000 Median : 1.000 Median :1.000
## Mean :0.04868 Mean : 1.543 Mean :1.141
## 3rd Qu.:0.00000 3rd Qu.: 2.000 3rd Qu.:2.000
## Max. :2.00000 Max. :10.000 Max. :8.000
##
## year score goals home_points away_points
## Min. :2014 1:1056 Min. : 0.000 Min. :0.000 Min. :0.000
## 1st Qu.:2015 x: 573 1st Qu.: 1.000 1st Qu.:0.000 1st Qu.:0.000
## Median :2016 2: 651 Median : 2.000 Median :1.000 Median :1.000
## Mean :2016 Mean : 2.684 Mean :1.641 Mean :1.108
## 3rd Qu.:2018 3rd Qu.: 4.000 3rd Qu.:3.000 3rd Qu.:3.000
## Max. :2019 Max. :12.000 Max. :3.000 Max. :3.000
##
## jornada total_off_target_shots total_on_target_shots total_shots
## Min. : 1.0 Min. : 1.00 Min. : 1.000 Min. : 5.00
## 1st Qu.:10.0 1st Qu.: 8.00 1st Qu.: 6.000 1st Qu.:20.00
## Median :19.5 Median :10.00 Median : 8.000 Median :23.00
## Mean :19.5 Mean : 9.97 Mean : 8.465 Mean :23.79
## 3rd Qu.:29.0 3rd Qu.:12.00 3rd Qu.:10.000 3rd Qu.:27.00
## Max. :38.0 Max. :22.00 Max. :23.000 Max. :46.00
##
## total_blocked_shots total_corners total_throw_ins total_pass_success
## Min. : 0.000 Min. : 1.000 Min. :16.00 Min. :100.0
## 1st Qu.: 4.000 1st Qu.: 7.000 1st Qu.:37.00 1st Qu.:146.0
## Median : 5.000 Median :10.000 Median :44.00 Median :154.0
## Mean : 5.386 Mean : 9.757 Mean :44.35 Mean :153.3
## 3rd Qu.: 7.000 3rd Qu.:12.000 3rd Qu.:51.00 3rd Qu.:162.0
## Max. :16.000 Max. :42.000 Max. :86.00 Max. :183.0
##
## total_aerials_won total_clearances total_fouls total_yellow_cards
## Min. : 4.0 Min. : 11.00 Min. : 8.00 Min. : 0.000
## 1st Qu.:24.0 1st Qu.: 32.00 1st Qu.:23.00 1st Qu.: 4.000
## Median :32.0 Median : 39.00 Median :27.00 Median : 5.000
## Mean :33.8 Mean : 40.22 Mean :27.68 Mean : 5.172
## 3rd Qu.:42.0 3rd Qu.: 47.00 3rd Qu.:32.00 3rd Qu.: 7.000
## Max. :95.0 Max. :102.00 Max. :52.00 Max. :13.000
##
## total_second_yellow_cards total_red_cards
## Min. :0.0000 Min. :0.0000
## 1st Qu.:0.0000 1st Qu.:0.0000
## Median :0.0000 Median :0.0000
## Mean :0.1404 Mean :0.0943
## 3rd Qu.:0.0000 3rd Qu.:0.0000
## Max. :2.0000 Max. :3.0000
##
4 ANÁLISIS EXPLORATORIO DE DATOS (EDA)
4.1 VARIABLES CUALITATIVAS
Las variables cualitativas de este data set son las siguientes:
- Home Team: Equipo local
- Away Team: Equipo visitante
- Score: Resultado 2-1 (eliminado en la fase de limpiado)
- Half Time Score: Resultado al descanso 1-1 (eliminado en la fase de limpiado)
- score: Resultado 1 X 2
4.1.1 RESUMEN NUMERICO
Exploramos los partidos que ha jugado cada equipo, nustra pretensión es comprobar que equipos han estado más años en primera división.
matches <- as.data.frame(table(train$Home_Team) + table(train$Away_Team)) %>% arrange(desc(Freq))
kable(matches, "pipe", align = "ll")| Var1 | Freq |
|---|---|
| ATHLETIC | 228 |
| ATLETICO MADRID | 228 |
| BARCELONA | 228 |
| CELTA | 228 |
| EIBAR | 228 |
| ESPANYOL | 228 |
| REAL MADRID | 228 |
| REAL SOCIEDAD | 228 |
| SEVILLA FC | 228 |
| VALENCIA | 228 |
| VILLARREAL | 228 |
| GETAFE | 190 |
| LEVANTE | 190 |
| REAL BETIS | 190 |
| ALAVÉS | 152 |
| DEPORTIVO | 152 |
| GRANADA | 152 |
| LEGANÉS | 152 |
| MÁLAGA | 152 |
| LAS PALMAS | 114 |
| RAYO VALLECANO | 114 |
| GIJÓN | 76 |
| GIRONA | 76 |
| OSASUNA | 76 |
| VALLADOLID | 76 |
| ALMERÍA | 38 |
| CÓRDOBA | 38 |
| ELCHE | 38 |
| HUESCA | 38 |
| MALLORCA | 38 |
| CÁDIZ CF | 0 |
Número y proporción de victorias, derrotas y empates.
kable(table(train$score), align = "ll")| Var1 | Freq |
|---|---|
| 1 | 1056 |
| x | 573 |
| 2 | 651 |
kable(prop.table(table(train$score))*100, align = "ll")| Var1 | Freq |
|---|---|
| 1 | 46.31579 |
| x | 25.13158 |
| 2 | 28.55263 |
Aquí observamos cuantos partidos han ganado, empatado y perdido cada equipo. Primero como equipo local y después como equipo visitante.
kable(with(train, table(Home_Team, score)),align = "llll")| 1 | x | 2 | |
|---|---|---|---|
| ALAVÉS | 30 | 23 | 23 |
| ALMERÍA | 3 | 7 | 9 |
| ATHLETIC | 56 | 34 | 24 |
| ATLETICO MADRID | 82 | 23 | 9 |
| BARCELONA | 94 | 13 | 7 |
| CÁDIZ CF | 0 | 0 | 0 |
| CELTA | 47 | 34 | 33 |
| CÓRDOBA | 1 | 6 | 12 |
| DEPORTIVO | 20 | 25 | 31 |
| EIBAR | 48 | 24 | 42 |
| ELCHE | 6 | 3 | 10 |
| ESPANYOL | 46 | 31 | 37 |
| GETAFE | 40 | 25 | 30 |
| GIJÓN | 12 | 8 | 18 |
| GIRONA | 11 | 9 | 18 |
| GRANADA | 24 | 22 | 30 |
| HUESCA | 5 | 6 | 8 |
| LAS PALMAS | 21 | 13 | 23 |
| LEGANÉS | 26 | 23 | 27 |
| LEVANTE | 35 | 29 | 31 |
| MÁLAGA | 30 | 17 | 29 |
| MALLORCA | 8 | 3 | 8 |
| OSASUNA | 9 | 14 | 15 |
| RAYO VALLECANO | 21 | 12 | 24 |
| REAL BETIS | 39 | 26 | 30 |
| REAL MADRID | 86 | 16 | 12 |
| REAL SOCIEDAD | 52 | 28 | 34 |
| SEVILLA FC | 74 | 25 | 15 |
| VALENCIA | 60 | 34 | 20 |
| VALLADOLID | 10 | 15 | 13 |
| VILLARREAL | 60 | 25 | 29 |
kable(with(train, table(Away_Team, score)),align = "llll")| 1 | x | 2 | |
|---|---|---|---|
| ALAVÉS | 42 | 12 | 22 |
| ALMERÍA | 13 | 1 | 5 |
| ATHLETIC | 53 | 29 | 32 |
| ATLETICO MADRID | 24 | 35 | 55 |
| BARCELONA | 16 | 26 | 72 |
| CÁDIZ CF | 0 | 0 | 0 |
| CELTA | 58 | 30 | 26 |
| CÓRDOBA | 12 | 5 | 2 |
| DEPORTIVO | 37 | 30 | 9 |
| EIBAR | 56 | 35 | 23 |
| ELCHE | 9 | 5 | 5 |
| ESPANYOL | 58 | 31 | 25 |
| GETAFE | 45 | 27 | 23 |
| GIJÓN | 22 | 11 | 5 |
| GIRONA | 16 | 10 | 12 |
| GRANADA | 46 | 17 | 13 |
| HUESCA | 11 | 6 | 2 |
| LAS PALMAS | 40 | 11 | 6 |
| LEGANÉS | 44 | 19 | 13 |
| LEVANTE | 57 | 20 | 18 |
| MÁLAGA | 45 | 18 | 13 |
| MALLORCA | 15 | 3 | 1 |
| OSASUNA | 21 | 9 | 8 |
| RAYO VALLECANO | 35 | 11 | 11 |
| REAL BETIS | 51 | 20 | 24 |
| REAL MADRID | 22 | 22 | 70 |
| REAL SOCIEDAD | 53 | 27 | 34 |
| SEVILLA FC | 48 | 29 | 37 |
| VALENCIA | 48 | 29 | 37 |
| VALLADOLID | 18 | 11 | 9 |
| VILLARREAL | 41 | 34 | 39 |
Lo representamos mediante porcentajes % de victorias, derrotas y empates de cada equipo. Primero como equipo local y después como equipo visitante.
kable(round(t((prop.table(with(train, table(score, Home_Team)), margin = 2)))*100,2), align = "llll")| 1 | x | 2 | |
|---|---|---|---|
| ALAVÉS | 39.47 | 30.26 | 30.26 |
| ALMERÍA | 15.79 | 36.84 | 47.37 |
| ATHLETIC | 49.12 | 29.82 | 21.05 |
| ATLETICO MADRID | 71.93 | 20.18 | 7.89 |
| BARCELONA | 82.46 | 11.40 | 6.14 |
| CÁDIZ CF | NaN | NaN | NaN |
| CELTA | 41.23 | 29.82 | 28.95 |
| CÓRDOBA | 5.26 | 31.58 | 63.16 |
| DEPORTIVO | 26.32 | 32.89 | 40.79 |
| EIBAR | 42.11 | 21.05 | 36.84 |
| ELCHE | 31.58 | 15.79 | 52.63 |
| ESPANYOL | 40.35 | 27.19 | 32.46 |
| GETAFE | 42.11 | 26.32 | 31.58 |
| GIJÓN | 31.58 | 21.05 | 47.37 |
| GIRONA | 28.95 | 23.68 | 47.37 |
| GRANADA | 31.58 | 28.95 | 39.47 |
| HUESCA | 26.32 | 31.58 | 42.11 |
| LAS PALMAS | 36.84 | 22.81 | 40.35 |
| LEGANÉS | 34.21 | 30.26 | 35.53 |
| LEVANTE | 36.84 | 30.53 | 32.63 |
| MÁLAGA | 39.47 | 22.37 | 38.16 |
| MALLORCA | 42.11 | 15.79 | 42.11 |
| OSASUNA | 23.68 | 36.84 | 39.47 |
| RAYO VALLECANO | 36.84 | 21.05 | 42.11 |
| REAL BETIS | 41.05 | 27.37 | 31.58 |
| REAL MADRID | 75.44 | 14.04 | 10.53 |
| REAL SOCIEDAD | 45.61 | 24.56 | 29.82 |
| SEVILLA FC | 64.91 | 21.93 | 13.16 |
| VALENCIA | 52.63 | 29.82 | 17.54 |
| VALLADOLID | 26.32 | 39.47 | 34.21 |
| VILLARREAL | 52.63 | 21.93 | 25.44 |
kable(round(t((prop.table(with(train, table(score, Away_Team)), margin = 2)))*100,2), align = "llll")| 1 | x | 2 | |
|---|---|---|---|
| ALAVÉS | 55.26 | 15.79 | 28.95 |
| ALMERÍA | 68.42 | 5.26 | 26.32 |
| ATHLETIC | 46.49 | 25.44 | 28.07 |
| ATLETICO MADRID | 21.05 | 30.70 | 48.25 |
| BARCELONA | 14.04 | 22.81 | 63.16 |
| CÁDIZ CF | NaN | NaN | NaN |
| CELTA | 50.88 | 26.32 | 22.81 |
| CÓRDOBA | 63.16 | 26.32 | 10.53 |
| DEPORTIVO | 48.68 | 39.47 | 11.84 |
| EIBAR | 49.12 | 30.70 | 20.18 |
| ELCHE | 47.37 | 26.32 | 26.32 |
| ESPANYOL | 50.88 | 27.19 | 21.93 |
| GETAFE | 47.37 | 28.42 | 24.21 |
| GIJÓN | 57.89 | 28.95 | 13.16 |
| GIRONA | 42.11 | 26.32 | 31.58 |
| GRANADA | 60.53 | 22.37 | 17.11 |
| HUESCA | 57.89 | 31.58 | 10.53 |
| LAS PALMAS | 70.18 | 19.30 | 10.53 |
| LEGANÉS | 57.89 | 25.00 | 17.11 |
| LEVANTE | 60.00 | 21.05 | 18.95 |
| MÁLAGA | 59.21 | 23.68 | 17.11 |
| MALLORCA | 78.95 | 15.79 | 5.26 |
| OSASUNA | 55.26 | 23.68 | 21.05 |
| RAYO VALLECANO | 61.40 | 19.30 | 19.30 |
| REAL BETIS | 53.68 | 21.05 | 25.26 |
| REAL MADRID | 19.30 | 19.30 | 61.40 |
| REAL SOCIEDAD | 46.49 | 23.68 | 29.82 |
| SEVILLA FC | 42.11 | 25.44 | 32.46 |
| VALENCIA | 42.11 | 25.44 | 32.46 |
| VALLADOLID | 47.37 | 28.95 | 23.68 |
| VILLARREAL | 35.96 | 29.82 | 34.21 |
4.1.2 VISUALIZACION VARIABLES CUALITATIVAS
Se puede apreciar que jugar en casa es un factor importante para ganar (aproximadamente la mitad de partidos los gana el de casa).
ggplot(train, aes(score, fill = score)) + geom_bar() + scale_fill_manual(values = c("limegreen", "lightblue", "indianred")) + labs(x = "Resultado", y = "Nº de resultados", title = "Nº de victorias Local / Visitante / Empate") + theme(plot.title = element_text(hjust = 0.5))
Aproximadamente el 46% de los equipos que juegan en casa ganan.
a <- train %>% group_by(score) %>% count(score)
b <- round(as.double(prop.table(table(train$score))*100,2), digits = 2)
datos <- a$n
pie3D(datos, col = c("limegreen", "lightblue", "indianred"), labels = b, explode = 0.05)
A continuación representamos mediante gráficos de barras la cantidad de partidos que juega cada equipo como local y como visitante en las 6 temporadas sometidas a estudio. Se puede apreciar claramente como hay un grupo de equipos que han jugado todos los partidos y por lo tanto nunca han descendido de categoría. Estos son: ATHLETIC, ATLETICO MADRID, BARCELONA, CELTA, EIBAR, ESPANYOL, REAL MADRID, REAL SOCIEDAD, SEVILLA FC, VALENCIA y VILLARREAL.
ggplot(train, aes(Home_Team, color = Home_Team, fill = Home_Team)) + geom_bar() + coord_flip() + labs(x = "Equipo", y = "Nº de partidos", title = "Nº de partidos como Local")+ theme(plot.title = element_text(hjust = 0.5))
ggplot(train, aes(Away_Team, color = Away_Team, fill = Away_Team)) + geom_bar() + coord_flip() + labs(x = "Equipo", y = "Nº de partidos", title = "Nº de partidos como Visitante")+ theme(plot.title = element_text(hjust = 0.5))
En este otro gráfico se pretende representar, por equipo, el número de victorias, derrotas y empates cuando se juega como local y cuando se juega como visitante. se puede apreciar como hay equipos que destacan en victorias jugando como local, ATLETICO MADRID, BARCELONA, REAL MADRID, SEVILLA FC. Además ATLETICO MADRID, BARCELONA, REAL MADRID también lo hacen como visitantes.
En cambio HUESCA, ELCHE, CORDOBA, MALLORCA y ALMERIA destacan justo por lo contrario, tiene un escaso número de victorias como equipo local y como visitante.
ggplot(train, aes(x = Home_Team, color = score, fill = score)) + geom_bar() + facet_wrap(~score) + coord_flip() + labs(x = "Equipo", y = "1 X 2", title = "Nº de Victorias - Empates - Derrotas como EQ. LOCAL")+ theme(plot.title = element_text(hjust = 0.5))
ggplot(train, aes(x = Away_Team, color = score, fill = score)) + geom_bar() + facet_wrap(~score) + coord_flip() + labs(x = "Equipo", y = "1 X 2", title = "Nº de Victorias - Empates - Derrotas como EQ. VISITANTE")+ theme(plot.title = element_text(hjust = 0.5))
4.2 VARIABLES CUANTITATIVAS
4.2.1 RESUMEN NUMERICO
POSESIÓN
summary(train$`Home_Team_Possession_%`)## Min. 1st Qu. Median Mean 3rd Qu. Max.
## 19.00 44.00 52.00 51.68 59.00 83.00summary(train$`Away_Team_Possession_%`)## Min. 1st Qu. Median Mean 3rd Qu. Max.
## 17.00 41.00 48.00 48.32 56.00 81.00
TIROS
No puerta
summary(train$Home_Team_Off_Target_Shots)## Min. 1st Qu. Median Mean 3rd Qu. Max.
## 0.000 4.000 5.000 5.635 7.000 18.000summary(train$Away_Team_Off_Target_Shots)## Min. 1st Qu. Median Mean 3rd Qu. Max.
## 0.000 3.000 4.000 4.336 6.000 14.000summary(train$total_off_target_shots)## Min. 1st Qu. Median Mean 3rd Qu. Max.
## 1.00 8.00 10.00 9.97 12.00 22.00
A puerta
summary(train$Home_Team_On_Target_Shots)## Min. 1st Qu. Median Mean 3rd Qu. Max.
## 0.000 3.000 4.000 4.757 6.000 17.000summary(train$Away_Team_On_Target_Shots)## Min. 1st Qu. Median Mean 3rd Qu. Max.
## 0.000 2.000 3.000 3.708 5.000 13.000summary(train$total_on_target_shots)## Min. 1st Qu. Median Mean 3rd Qu. Max.
## 1.000 6.000 8.000 8.465 10.000 23.000
Total
summary(train$Home_Team_Total_Shots)## Min. 1st Qu. Median Mean 3rd Qu. Max.
## 2.00 10.00 13.00 13.36 16.00 33.00summary(train$Away_Team_Total_Shots)## Min. 1st Qu. Median Mean 3rd Qu. Max.
## 0.00 7.00 10.00 10.43 13.00 28.00summary(train$total_shots)## Min. 1st Qu. Median Mean 3rd Qu. Max.
## 5.00 20.00 23.00 23.79 27.00 46.00
BLOQUEOS
summary(train$Home_Team_Blocked_Shots)## Min. 1st Qu. Median Mean 3rd Qu. Max.
## 0.000 2.000 3.000 2.978 4.000 12.000summary(train$Away_Team_Blocked_Shots)## Min. 1st Qu. Median Mean 3rd Qu. Max.
## 0.000 1.000 2.000 2.408 3.000 11.000summary(train$total_blocked_shots)## Min. 1st Qu. Median Mean 3rd Qu. Max.
## 0.000 4.000 5.000 5.386 7.000 16.000
CORNERS
summary(train$Home_Team_Corners)## Min. 1st Qu. Median Mean 3rd Qu. Max.
## 0.000 3.000 5.000 5.556 7.000 20.000summary(train$Away_Team_Corners)## Min. 1st Qu. Median Mean 3rd Qu. Max.
## 0.000 2.000 4.000 4.202 6.000 32.000summary(train$total_corners)## Min. 1st Qu. Median Mean 3rd Qu. Max.
## 1.000 7.000 10.000 9.757 12.000 42.000
CENTROS
summary(train$Home_Team_Throw_Ins)## Min. 1st Qu. Median Mean 3rd Qu. Max.
## 5.00 18.00 22.00 22.76 27.00 49.00summary(train$Away_Team_Throw_Ins)## Min. 1st Qu. Median Mean 3rd Qu. Max.
## 3.00 17.00 21.00 21.59 26.00 45.00summary(train$total_throw_ins)## Min. 1st Qu. Median Mean 3rd Qu. Max.
## 16.00 37.00 44.00 44.35 51.00 86.00
PASES
summary(train$`Home_Team_Pass_Success_%`)## Min. 1st Qu. Median Mean 3rd Qu. Max.
## 46.00 73.00 78.00 77.64 83.00 93.00summary(train$`Away_Team_Pass_Success_%`)## Min. 1st Qu. Median Mean 3rd Qu. Max.
## 41.0 71.0 77.0 75.7 82.0 93.0summary(train$total_pass_success)## Min. 1st Qu. Median Mean 3rd Qu. Max.
## 100.0 146.0 154.0 153.3 162.0 183.0
BALONES AEREOS
summary(train$Home_Team_Aerials_Won)## Min. 1st Qu. Median Mean 3rd Qu. Max.
## 2.00 12.00 16.00 17.12 22.00 50.00summary(train$Away_Team_Aerials_Won)## Min. 1st Qu. Median Mean 3rd Qu. Max.
## 0.00 11.00 16.00 16.68 21.00 53.00summary(train$total_aerials_won)## Min. 1st Qu. Median Mean 3rd Qu. Max.
## 4.0 24.0 32.0 33.8 42.0 95.0
DESPEJES
summary(train$Home_Team_Clearances)## Min. 1st Qu. Median Mean 3rd Qu. Max.
## 1.00 12.00 17.00 18.01 23.00 61.00summary(train$Away_Team_Clearances)## Min. 1st Qu. Median Mean 3rd Qu. Max.
## 2.00 15.00 21.00 22.21 28.00 63.00summary(train$total_clearances)## Min. 1st Qu. Median Mean 3rd Qu. Max.
## 11.00 32.00 39.00 40.22 47.00 102.00
FALTAS
summary(train$Home_Team_Fouls)## Min. 1st Qu. Median Mean 3rd Qu. Max.
## 1.00 11.00 14.00 13.82 17.00 33.00summary(train$Away_Team_Fouls)## Min. 1st Qu. Median Mean 3rd Qu. Max.
## 0.00 11.00 14.00 13.86 17.00 30.00summary(train$total_fouls)## Min. 1st Qu. Median Mean 3rd Qu. Max.
## 8.00 23.00 27.00 27.68 32.00 52.00
TARJETAS AMARILLAS
summary(train$Home_Team_Yellow_Cards)## Min. 1st Qu. Median Mean 3rd Qu. Max.
## 0.000 1.000 2.000 2.465 3.000 8.000summary(train$Away_Team_Yellow_Cards)## Min. 1st Qu. Median Mean 3rd Qu. Max.
## 0.000 2.000 3.000 2.707 4.000 8.000summary(train$total_yellow_cards)## Min. 1st Qu. Median Mean 3rd Qu. Max.
## 0.000 4.000 5.000 5.172 7.000 13.000
SEGUNDAS TARJETAS AMARILLAS
summary(train$Home_Team_Second_Yellow_Cards)## Min. 1st Qu. Median Mean 3rd Qu. Max.
## 0.00000 0.00000 0.00000 0.05833 0.00000 2.00000summary(train$Away_Team_Second_Yellow_Cards)## Min. 1st Qu. Median Mean 3rd Qu. Max.
## 0.00000 0.00000 0.00000 0.08202 0.00000 2.00000summary(train$total_second_yellow_cards)## Min. 1st Qu. Median Mean 3rd Qu. Max.
## 0.0000 0.0000 0.0000 0.1404 0.0000 2.0000
TARJETAS ROJAS
summary(train$Home_Team_Red_Cards)## Min. 1st Qu. Median Mean 3rd Qu. Max.
## 0.00000 0.00000 0.00000 0.04561 0.00000 2.00000summary(train$Away_Team_Red_Cards)## Min. 1st Qu. Median Mean 3rd Qu. Max.
## 0.00000 0.00000 0.00000 0.04868 0.00000 2.00000summary(train$total_red_cards)## Min. 1st Qu. Median Mean 3rd Qu. Max.
## 0.0000 0.0000 0.0000 0.0943 0.0000 3.0000
GOLES
summary(train$Home_Team_Goals_Scored)## Min. 1st Qu. Median Mean 3rd Qu. Max.
## 0.000 1.000 1.000 1.543 2.000 10.000summary(train$Away_Team_Goals_Scored)## Min. 1st Qu. Median Mean 3rd Qu. Max.
## 0.000 0.000 1.000 1.141 2.000 8.000summary(train$goals)## Min. 1st Qu. Median Mean 3rd Qu. Max.
## 0.000 1.000 2.000 2.684 4.000 12.000
4.2.2 VISUALIZACION VARIABLES CUANTITATIVAS
POSESIÓN
Histograma con curva de densidad sobre la posesión del equipo local.
ggplot(train, aes(`Home_Team_Possession_%`)) + geom_histogram(aes(y=..density..), position = "dodge", fun = "sum",color = 'black', fill = 'orange') + geom_density(alpha=.3, fill = "blue") + labs(title="Gráfica % Posesión EQ. LOCAL", x="% de Posesión", y="Cantidad") + theme(plot.title=element_text(hjust = 0.5))
Porcentaje de posesión del equipo local respecto al resultado 1 X 2.
ggplot(train,aes(score ,`Home_Team_Possession_%`)) + geom_bar(position = "dodge", stat = "summary", fun = "mean", color = 'black', fill = 'orange') + labs(title="Gráfica Pep", x="resultado", y="posesión local") + theme(plot.title=element_text(hjust = 0.5))
Histograma con curva de densidad sobre la posesión del equipo visitante
ggplot(train, aes(`Away_Team_Possession_%`)) + geom_histogram(aes(y=..density..), position = "dodge", fun = "sum",color = 'black', fill = 'orange') + geom_density(alpha=.3, fill = "blue") + labs(title="Gráfica % Posesión EQ. VISITANTE", x="% de Posesión", y="Cantidad") + theme(plot.title=element_text(hjust = 0.5))
Porcentaje de posesión del equipo visitante respecto al resultado 1 X 2.
ggplot(train,aes(score ,`Away_Team_Possession_%`)) + geom_bar(position = "dodge", stat = "summary", fun = "mean", color = 'black', fill = 'orange') + labs(title="Gráfica Pep", x="resultado", y="posesión visitante") + theme(plot.title=element_text(hjust = 0.5))
TIROS
TOTALES
Histograma con curva de densidad sobre el total de tiros por partido.
ggplot(train, aes(`total_shots`)) + geom_histogram(aes(y=..density..), position = "dodge", fun = "sum",color = 'black', fill = 'pink') + geom_density(alpha=.3, fill = "blue") + labs(title="Gráfica tiros totales por partido", x="tiros", y="Cantidad") + theme(plot.title=element_text(hjust = 0.5))
Porcentaje de tiros totales respecto al resultado 1 X 2. En los partidos el número total de disparos está bastante igualado con independencia de la victoria, derrota o empate.
ggplot(train,aes(score , total_shots)) + geom_bar(position = "dodge", stat = "summary", fun = "mean", color = 'black', fill = 'pink') + labs(title="Media de disparos por partido", x="resultado", y="disparos") + theme(plot.title=element_text(hjust = 0.5))
Histograma con curva de densidad sobre el total de tiros del equipo local por partido.
ggplot(train, aes(`Home_Team_Total_Shots`)) + geom_histogram(aes(y=..density..), position = "dodge", fun = "sum",color = 'black', fill = 'pink') + geom_density(alpha=.3, fill = "blue") + labs(title="Gráfica tiros totales por partido EQ. LOCAL", x="tiros", y="Cantidad") + theme(plot.title=element_text(hjust = 0.5))
Porcentaje de tiros totales del equipo local respecto al resultado 1 X 2. El número de tiros no influye mucho en el resultado (gane, pierda o empate suelen ser similares)
ggplot(train,aes(score ,Home_Team_Total_Shots)) + geom_bar(position = "dodge", stat = "summary", fun = "mean", color = 'black', fill = 'pink') + labs(title="media de tiros EQ. LOCAL por partido", x="resultado", y="tiros local") + theme(plot.title=element_text(hjust = 0.5))
Histograma con curva de densidad sobre el total de tiros del equipo visitante por partido.
ggplot(train, aes(`Away_Team_Total_Shots`)) + geom_histogram(aes(y=..density..), position = "dodge", fun = "sum",color = 'black', fill = 'pink') + geom_density(alpha=.3, fill = "blue") + labs(title="Gráfica tiros totales por partido EQ. VISITANTE", x="tiros", y="Cantidad") + theme(plot.title=element_text(hjust = 0.5))
Porcentaje de tiros totales del equipo local respecto al resultado 1 X 2. El número de tiros no influye mucho en el resultado (gane, pierda o empate suelen ser similares)
ggplot(train,aes(score ,Away_Team_Total_Shots)) + geom_bar(position = "dodge", stat = "summary", fun = "mean", color = 'black', fill = 'pink') + labs(title="media de tiros EQ. VISITANTE por partido", x="resultado", y="tiros local") + theme(plot.title=element_text(hjust = 0.5))
A PUERTA
Histograma con curva de densidad sobre el total de tiros por partido.
ggplot(train, aes(`total_on_target_shots`)) + geom_histogram(aes(y=..density..), position = "dodge", fun = "sum",color = 'black', fill = 'pink') + geom_density(alpha=.3, fill = "blue") + labs(title="Gráfica tiros totales a puerta por partido", x="tiros a puerta", y="Cantidad") + theme(plot.title=element_text(hjust = 0.5))
Porcentaje de tiros totales a puerta respecto al resultado 1 X 2.
ggplot(train,aes(score , total_on_target_shots)) + geom_bar(position = "dodge", stat = "summary", fun = "mean", color = 'black', fill = 'pink') + labs(title="Media de disparos a puerta por partido", x="resultado", y="disparos a puerta") + theme(plot.title=element_text(hjust = 0.5))
Histograma con curva de densidad sobre el total de tiros del equipo local por partido.
ggplot(train, aes(`Home_Team_On_Target_Shots`)) + geom_histogram(aes(y=..density..), position = "dodge", fun = "sum",color = 'black', fill = 'pink') + geom_density(alpha=.3, fill = "blue") + labs(title="Gráfica tiros totales a puerta por partido EQ. LOCAL", x="tiros", y="Cantidad") + theme(plot.title=element_text(hjust = 0.5))
Porcentaje de tiros totales del equipo local respecto al resultado 1 X 2.
ggplot(train,aes(score ,`Home_Team_On_Target_Shots`)) + geom_bar(position = "dodge", stat = "summary", fun = "mean", color = 'black', fill = 'pink') + labs(title="media de tiros EQ. LOCAL por partido", x="resultado", y="tiros local a puerta") + theme(plot.title=element_text(hjust = 0.5))
Histograma con curva de densidad sobre el total de tiros del equipo visitante por partido.
ggplot(train, aes(`Away_Team_On_Target_Shots`)) + geom_histogram(aes(y=..density..), position = "dodge", fun = "sum",color = 'black', fill = 'pink') + geom_density(alpha=.3, fill = "blue") + labs(title="Gráfica tiros totales a puerta por partido EQ. VISITANTE", x="tiros", y="Cantidad") + theme(plot.title=element_text(hjust = 0.5))
Porcentaje de tiros totales del equipo local respecto al resultado 1 X 2. El número de tiros no influye mucho en el resultado (gane, pierda o empate suelen ser similares)
ggplot(train,aes(score ,`Away_Team_On_Target_Shots`)) + geom_bar(position = "dodge", stat = "summary", fun = "mean", color = 'black', fill = 'pink') + labs(title="media de tiros EQ. VISITANTE por partido", x="resultado", y="tiros local") + theme(plot.title=element_text(hjust = 0.5))
Por motivos de simplicidad en el análisis NO hacemos el mismo ejercicio para los tiros que no van a puerta.
BLOQUEOS
Histograma con curva de densidad sobre el total de tiros bloqueados por partido.
ggplot(train, aes(`total_blocked_shots`)) + geom_histogram(aes(y=..density..), position = "dodge", fun = "sum",color = 'black', fill = 'grey') + geom_density(alpha=.3, fill = "blue") + labs(title="Gráfica tiros bloqueados totales", x="tiros bloqueados", y="Cantidad") + theme(plot.title=element_text(hjust = 0.5))
Bloqueos totales respecto al resultado 1 X 2.
ggplot(train,aes(score ,total_blocked_shots)) + geom_bar(position = "dodge", stat = "summary", fun = "mean", color = 'black', fill = "grey") + labs(title="Media de tiros bloqueados por partido", x="resultado", y="tiros bloqueados") + theme(plot.title=element_text(hjust = 0.5))
Histograma con curva de densidad sobre el total de tiros bloqueados por partido del equipo local.
ggplot(train, aes(`Home_Team_Blocked_Shots`)) + geom_histogram(aes(y=..density..), position = "dodge", fun = "sum",color = 'black', fill = 'grey') + geom_density(alpha=.3, fill = "blue") + labs(title="Gráfica tiros bloqueados totales EQ. LOCAL", x="tiros bloqueados eq. local", y="Cantidad") + theme(plot.title=element_text(hjust = 0.5))
Histograma con curva de densidad sobre el total de tiros bloqueados por partido del equipo visitante.
ggplot(train, aes(`Away_Team_Blocked_Shots`)) + geom_histogram(aes(y=..density..), position = "dodge", fun = "sum",color = 'black', fill = 'grey') + geom_density(alpha=.3, fill = "blue") + labs(title="Gráfica tiros bloqueados totales EQ. VISITANTE", x="tiros bloqueados eq. visitante", y="Cantidad") + theme(plot.title=element_text(hjust = 0.5))
CORNERS
Histograma con curva de densidad sobre el total de corners por partido.
ggplot(train, aes(`total_corners`)) + geom_histogram(aes(y=..density..), position = "dodge", fun = "sum",color = 'black', fill = 'blue') + geom_density(alpha=.3, fill = "yellow") + labs(title="Gráfica corners totales", x="corners", y="Cantidad") + theme(plot.title=element_text(hjust = 0.5))
Corners totales respecto al resultado 1 X 2. El numero de corners no parece un factor determinante en la victoria se puede observar como con independencia del ganadar el numero de corners está muy repartido
ggplot(train,aes(score ,total_corners)) + geom_bar(position = "dodge", stat = "summary", fun = "mean", color = 'black', fill = 'blue') + labs(title="Media de corners por partido", x="resultado", y="corners") + theme(plot.title=element_text(hjust = 0.5))
Histograma con curva de densidad sobre el total de corners por partido del equipo local.
ggplot(train, aes(`Home_Team_Corners`)) + geom_histogram(aes(y=..density..), position = "dodge", fun = "sum",color = 'black', fill = 'blue') + geom_density(alpha=.3, fill = "yellow") + labs(title="Gráfica corners totales EQ. LOCAL", x="tiros bloqueados eq. local", y="Cantidad") + theme(plot.title=element_text(hjust = 0.5))
Histograma con curva de densidad sobre el total de corners por partido del equipo visitante.
ggplot(train, aes(`Away_Team_Corners`)) + geom_histogram(aes(y=..density..), position = "dodge", fun = "sum",color = 'black', fill = 'blue') + geom_density(alpha=.3, fill = "yellow") + labs(title="Gráfica corners totales EQ. VISITANTE", x="tiros bloqueados eq. visitante", y="Cantidad") + theme(plot.title=element_text(hjust = 0.5))
CENTROS
Histograma con curva de densidad sobre el total de centros por partido.
ggplot(train, aes(`total_throw_ins`)) + geom_histogram(aes(y=..density..), position = "dodge", fun = "sum",color = 'black', fill = 'lightblue') + geom_density(alpha=.3, fill = "yellow") + labs(title="Gráfica centros totales", x="centros", y="Cantidad") + theme(plot.title=element_text(hjust = 0.5))
Centros totales respecto al resultado 1 X 2. El numero de centros no parece un factor determinante en la victoria se puede observar como con independencia del ganadar el numero de centros está muy repartido.
ggplot(train,aes(score ,total_throw_ins)) + geom_bar(position = "dodge", stat = "summary", fun = "mean", color = 'black', fill = 'lightblue') + labs(title="Media de centros por partido", x="resultado", y="centros") + theme(plot.title=element_text(hjust = 0.5))
Histograma con curva de densidad sobre el total de centros por partido del equipo local.
ggplot(train, aes(`Home_Team_Throw_Ins`)) + geom_histogram(aes(y=..density..), position = "dodge", fun = "sum",color = 'black', fill = 'lightblue') + geom_density(alpha=.3, fill = "yellow") + labs(title="Gráfica centros totales EQ. LOCAL", x="centros eq. local", y="Cantidad") + theme(plot.title=element_text(hjust = 0.5))
Histograma con curva de densidad sobre el total de centros por partido del equipo visitante.
ggplot(train, aes(`Away_Team_Throw_Ins`)) + geom_histogram(aes(y=..density..), position = "dodge", fun = "sum",color = 'black', fill = 'lightblue') + geom_density(alpha=.3, fill = "yellow") + labs(title="Gráfica centros totales EQ. VISITANTE", x="centros eq. visitante", y="Cantidad") + theme(plot.title=element_text(hjust = 0.5))
PASES
Histograma con curva de densidad sobre el total de pases exitosos por partido.
ggplot(train, aes(`total_pass_success`)) + geom_histogram(aes(y=..density..), position = "dodge", fun = "sum",color = 'black', fill = "white") + geom_density(alpha=.3, fill = "yellow") + labs(title="Gráfica pases exitosos totales", x="pases exitosos", y="Cantidad") + theme(plot.title=element_text(hjust = 0.5))
Pases totales respecto al resultado 1 X 2. El numero de centros no parece un factor determinante en la victoria se puede observar como con independencia del ganadar el numero de centros está muy repartido.
ggplot(train,aes(score ,`total_pass_success`)) + geom_bar(position = "dodge", stat = "summary", fun = "mean", color = 'black', fill = "white") + labs(title="Media de pases exitosos por partido", x="resultado", y="pases exitosos") + theme(plot.title=element_text(hjust = 0.5))
Histograma con curva de densidad sobre el total de centros por partido del equipo local.
ggplot(train, aes(`Home_Team_Pass_Success_%`)) + geom_histogram(aes(y=..density..), position = "dodge", fun = "sum",color = 'black', fill = "white") + geom_density(alpha=.3, fill = "yellow") + labs(title="Gráfica pases exitosos totales EQ. LOCAL", x="pases exitosos eq. local", y="Cantidad") + theme(plot.title=element_text(hjust = 0.5))
Histograma con curva de densidad sobre el total de centros por partido del equipo visitante.
ggplot(train, aes(`Away_Team_Pass_Success_%`)) + geom_histogram(aes(y=..density..), position = "dodge", fun = "sum",color = 'black', fill = "white") + geom_density(alpha=.3, fill = "yellow") + labs(title="Gráfica pases exitosos totales EQ. VISITANTE", x="pases exitosos eq. visitante", y="Cantidad") + theme(plot.title=element_text(hjust = 0.5))
BALONES AEREOS
Histograma con curva de densidad sobre el total de balones aéreos ganadoss por partido.
ggplot(train, aes(`total_aerials_won`)) + geom_histogram(aes(y=..density..), position = "dodge", fun = "sum",color = 'black', fill = "brown") + geom_density(alpha=.3, fill = "yellow") + labs(title="Gráfica balones aéreos ganados totales", x="balones aéreos ganados", y="Cantidad") + theme(plot.title=element_text(hjust = 0.5))
Balones aéreos ganados totales respecto al resultado 1 X 2. El número de duelos aereos no parece un factor determinante en la victoria.
ggplot(train,aes(score ,total_aerials_won)) + geom_bar(position = "dodge", stat = "summary", fun = "mean", color = 'black', fill = "brown") + labs(title="Media de balones aéreos ganados por partido", x="resultado", y="duelos aereos") + theme(plot.title=element_text(hjust = 0.5))
Histograma con curva de densidad sobre el total de centros por partido del equipo local.
ggplot(train, aes(`Home_Team_Aerials_Won`)) + geom_histogram(aes(y=..density..), position = "dodge", fun = "sum",color = 'black', fill = "brown") + geom_density(alpha=.3, fill = "yellow") + labs(title="Gráfica balones aéreos ganados totales EQ. LOCAL", x="pases exitosos eq. local", y="Cantidad") + theme(plot.title=element_text(hjust = 0.5))
Histograma con curva de densidad sobre el total de centros por partido del equipo visitante.
ggplot(train, aes(`Away_Team_Aerials_Won`)) + geom_histogram(aes(y=..density..), position = "dodge", fun = "sum",color = 'black', fill = "brown") + geom_density(alpha=.3, fill = "yellow") + labs(title="Gráfica balones aéreos ganados totales EQ. VISITANTE", x="pases exitosos eq. visitante", y="Cantidad") + theme(plot.title=element_text(hjust = 0.5))
DESPEJES
Histograma con curva de densidad sobre el total de despejes por partido.
ggplot(train, aes(`total_clearances`)) + geom_histogram(aes(y=..density..), position = "dodge", fun = "sum",color = 'black', fill = "lightgreen") + geom_density(alpha=.3, fill = "blue") + labs(title="Gráfica despejes totales", x="despejes", y="Cantidad") + theme(plot.title=element_text(hjust = 0.5))
Despejes totales respecto al resultado 1 X 2. El número de despejes no parece un factor determinante en la victoria incluso parece que a mayor número de despejes medios el partido parece más probable que acabe en empate
ggplot(train,aes(score ,total_clearances)) + geom_bar(position = "dodge", stat = "summary", fun = "mean", color = 'black', fill = 'lightgreen') + labs(title="Media de despejes por partido", x="resultado", y="despejes") + theme(plot.title=element_text(hjust = 0.5))
Histograma con curva de densidad sobre el total de despejes del equipo local.
ggplot(train, aes(`Home_Team_Clearances`)) + geom_histogram(aes(y=..density..), position = "dodge", fun = "sum",color = 'black', fill = "lightgreen") + geom_density(alpha=.3, fill = "blue") + labs(title="Gráfica despejes totales EQ. LOCAL", x="despejes eq. local", y="Cantidad") + theme(plot.title=element_text(hjust = 0.5))
Histograma con curva de densidad sobre el total de despejes del equipo visitante.
ggplot(train, aes(`Away_Team_Clearances`)) + geom_histogram(aes(y=..density..), position = "dodge", fun = "sum",color = 'black', fill = "lightgreen") + geom_density(alpha=.3, fill = "blue") + labs(title="Gráfica despejes totales EQ. VISITANTE", x="despejes eq. visitante", y="Cantidad") + theme(plot.title=element_text(hjust = 0.5))
FALTAS
Histograma con curva de densidad sobre el total de faltas por partido.
ggplot(train, aes(`total_fouls`)) + geom_histogram(aes(y=..density..), position = "dodge", fun = "sum",color = 'black', fill = "lightyellow") + geom_density(alpha=.3, fill = "blue") + labs(title="Gráfica faltas totales", x="faltas", y="Cantidad") + theme(plot.title=element_text(hjust = 0.5))
Faltas totales respecto al resultado 1 X 2. El número de faltas no parece un factor determinante.
ggplot(train,aes(score ,total_fouls)) + geom_bar(position = "dodge", stat = "summary", fun = "mean", color = 'black', fill = 'lightyellow') + labs(title="Media de faltas por partido", x="resultado", y="faltas") + theme(plot.title=element_text(hjust = 0.5))
Histograma con curva de densidad sobre el total de faltas del equipo local.
ggplot(train, aes(`Home_Team_Fouls`)) + geom_histogram(aes(y=..density..), position = "dodge", fun = "sum",color = 'black', fill = "lightyellow") + geom_density(alpha=.3, fill = "blue") + labs(title="Gráfica faltas totales EQ. LOCAL", x="faltas eq. local", y="Cantidad") + theme(plot.title=element_text(hjust = 0.5))
Histograma con curva de densidad sobre el total faltas del equipo visitante.
ggplot(train, aes(`Away_Team_Fouls`)) + geom_histogram(aes(y=..density..), position = "dodge", fun = "sum",color = 'black', fill = "lightyellow") + geom_density(alpha=.3, fill = "blue") + labs(title="Gráfica faltas totales EQ. VISITANTE", x="faltas eq. visitante", y="Cantidad") + theme(plot.title=element_text(hjust = 0.5))
TARJETAS AMARILLAS
Histograma con curva de densidad sobre el total de tarjetas amarillas por partido.
ggplot(train, aes(`total_yellow_cards`)) + geom_histogram(aes(y=..density..), position = "dodge", fun = "sum",color = 'black', fill = "yellow") + geom_density(alpha=.3, fill = "blue") + labs(title="Gráfica tarjetas amarillas totales", x="tarjetas amarillas", y="Cantidad") + theme(plot.title=element_text(hjust = 0.5))
Tarjetas amarillas totales respecto al resultado 1 X 2. El numero de tarjetas amarillas no parece un factor determinante.
ggplot(train,aes(score ,total_yellow_cards)) + geom_bar(position = "dodge", stat = "summary", fun = "mean", color = 'black', fill = 'yellow') + labs(title="Media de amarillas por partido", x="resultado", y="amarillas") + theme(plot.title=element_text(hjust = 0.5))
Histograma con curva de densidad sobre el total de tarjetas amarillas del equipo local.
ggplot(train, aes(`Home_Team_Yellow_Cards`)) + geom_histogram(aes(y=..density..), position = "dodge", fun = "sum",color = 'black', fill = "yellow") + geom_density(alpha=.3, fill = "blue") + labs(title="Gráfica tarjetas amarillas totales EQ. LOCAL", x="tarjetas amarillas eq. local", y="Cantidad") + theme(plot.title=element_text(hjust = 0.5))
Histograma con curva de densidad sobre el total tarjetas amarillas del equipo visitante.
ggplot(train, aes(`Away_Team_Yellow_Cards`)) + geom_histogram(aes(y=..density..), position = "dodge", fun = "sum",color = 'black', fill = "yellow") + geom_density(alpha=.3, fill = "blue") + labs(title="Gráfica tarjetas amarillas totales EQ. VISITANTE", x="tarjetas amarillas eq. visitante", y="Cantidad") + theme(plot.title=element_text(hjust = 0.5))
TARJETAS ROJAS
Histograma con curva de densidad sobre el total de tarjetas rojas por partido.
ggplot(train, aes(`total_red_cards`)) + geom_histogram(aes(y=..density..), position = "dodge", fun = "sum",color = 'black', fill = "red") + geom_density(alpha=.3, fill = "green") + labs(title="Gráfica tarjetas rojas totales", x="tarjetas rojas", y="Cantidad") + theme(plot.title=element_text(hjust = 0.5))
Rojas totales respecto al resultado 1 X 2. El numero de tarjetas rojas no parece un factor determinante.
ggplot(train,aes(score ,total_red_cards)) + geom_bar(position = "dodge", stat = "summary", fun = "mean", color = 'black', fill = 'red') + labs(title="Media de rojas por partido", x="resultado", y="rojas") + theme(plot.title=element_text(hjust = 0.5))
Histograma con curva de densidad sobre el total de tarjetas rojas del equipo local.
ggplot(train, aes(`Home_Team_Red_Cards`)) + geom_histogram(aes(y=..density..), position = "dodge", fun = "sum",color = 'black', fill = "red") + geom_density(alpha=.3, fill = "green") + labs(title="Gráfica tarjetas rojas totales EQ. LOCAL", x="tarjetas rojas eq. local", y="Cantidad") + theme(plot.title=element_text(hjust = 0.5))
Histograma con curva de densidad sobre el total tarjetas rojas del equipo visitante.
ggplot(train, aes(`Away_Team_Red_Cards`)) + geom_histogram(aes(y=..density..), position = "dodge", fun = "sum",color = 'black', fill = "red") + geom_density(alpha=.3, fill = "green") + labs(title="Gráfica tarjetas rojas totales EQ. VISITANTE", x="tarjetas rojas eq. visitante", y="Cantidad") + theme(plot.title=element_text(hjust = 0.5))
GOLES
Histograma con curva de densidad sobre el total de tarjetas rojas por partido.
ggplot(train, aes(`goals`)) + geom_histogram(aes(y=..density..), position = "dodge", fun = "sum",color = 'black', fill = "limegreen") + geom_density(alpha=.3, fill = "red") + labs(title="Gráfica goles totales", x="goles", y="Cantidad") + theme(plot.title=element_text(hjust = 0.5))
En los partidos con victorias locales hay más goles de media que en los que gana el visitante (y bastante más que en los que hay empate). Por tanto, un partido con más goles es más probable que no acabe en empate.
ggplot(train,aes(score ,goals, fill = score)) + geom_bar(position = "dodge", stat = "summary", fun = "mean") + scale_fill_manual(values = c("limegreen", "lightblue", "indianred")) + labs(title="Media de goles por partido", x="resultado", y="goles") + theme(plot.title=element_text(hjust = 0.5))
Histograma con curva de densidad sobre el total de goles del equipo local.
ggplot(train, aes(`Home_Team_Goals_Scored`)) + geom_histogram(aes(y=..density..), position = "dodge", fun = "sum",color = 'black', fill = "limegreen") + geom_density(alpha=.3, fill = "green") + labs(title="Gráfica goles totales EQ. LOCAL", x="goles eq. local", y="Cantidad") + theme(plot.title=element_text(hjust = 0.5))
Histograma con curva de densidad sobre el total goles del equipo visitante.
ggplot(train, aes(`Away_Team_Goals_Scored`)) + geom_histogram(aes(y=..density..), position = "dodge", fun = "sum",color = 'black', fill = "limegreen") + geom_density(alpha=.3, fill = "green") + labs(title="Gráfica goles totales EQ. VISITANTE", x="goles eq. visitante", y="Cantidad") + theme(plot.title=element_text(hjust = 0.5))
Cuando el equipo local gana, mayor es su media de goles. Es decir, a mas goles, mas victorias. #JUNTAR ESTA GRAFICA CON LA ANTERIOR (cada columna coloreada con los goles locales y visitantes)
ggplot(train,aes(score ,Home_Team_Goals_Scored, Away_Team_Goals_Scored)) + geom_bar(position = "dodge", stat = "summary", fun = "mean", color = 'black', fill = 'green') + labs(title="media de goles EQ. LOCAL por partido", x="resultado", y="goles local") + theme(plot.title=element_text(hjust = 0.5))
Cuando el equipo local pierde, mayor es la media de goles del visitante. Es decir, a mas goles encajados, mas derrotas (obvio pero habia que comprobarlo)
ggplot(train,aes(score ,Away_Team_Goals_Scored)) + geom_bar(position = "dodge", stat = "summary", fun = "mean", color = 'black', fill = 'green') + labs(title="media de goles EQ. VISITANTE por partido", x="resultado", y="goles visitante") + theme(plot.title=element_text(hjust = 0.5))
ggplot(train, aes(x = goals, fill = score)) + geom_dotplot(binwidth = 0.1)
GRÁFICOS DOTPLOT POR AÑO / JORNADA
goles_year_jorn <- data_frame(train %>% group_by(year, jornada) %>% summarise( total_goles = sum(goals)))
tiros_year_jorn <- data_frame(train %>% group_by(year, jornada) %>% summarise( total_tiros = sum(total_shots)))
tiros_block_year_jorn <- data_frame(train %>% group_by(year, jornada) %>% summarise( total_tiros_bloqueados = sum(total_blocked_shots)))
corners_year_jorn <- data_frame(train %>% group_by(year, jornada) %>% summarise( total_corners = sum(total_corners)))
centros_year_jorn <- data_frame(train %>% group_by(year, jornada) %>% summarise( total_throw_ins = sum(total_throw_ins)))
pases_year_jorn <- data_frame(train %>% group_by(year, jornada) %>% summarise( total_pass_succ = sum(total_pass_success)))
d_aer_year_jorn <- data_frame(train %>% group_by(year, jornada) %>% summarise( total_d_aer = sum(total_aerials_won)))
t_despj_year_jorn <- data_frame(train %>% group_by(year, jornada) %>% summarise( total_clearances = sum(total_clearances)))
faltas_year_jorn <- data_frame(train %>% group_by(year, jornada) %>% summarise( total_fouls = sum(total_fouls)))
amarll_year_jorn <- data_frame(train %>% group_by(year, jornada) %>% summarise( total_yellow_cards = sum(total_yellow_cards)))
rojas_year_jorn <- data_frame(train %>% group_by(year, jornada) %>% summarise( total_red_cards = sum(total_red_cards)))
ggplot(goles_year_jorn, aes(x = jornada, y = total_goles)) + geom_point() + facet_grid(~year) + labs(x = "jornadas", y = "Nº de goles", title = "Nº de goles por jornada / Año") + theme(plot.title = element_text(hjust = 0.5)) + xlim(1,38)
ggplot(tiros_year_jorn, aes(x = jornada, y = total_tiros)) + geom_point() + facet_grid(~year) + labs(x = "jornadas", y = "Nº de disparos", title = "Nº de disparos por jornada / Año") + theme(plot.title = element_text(hjust = 0.5))
ggplot(tiros_block_year_jorn, aes(x = jornada, y = total_tiros_bloqueados)) + geom_point() + facet_grid(~year) + labs(x = "jornadas", y = "Nº de disparos_bloqueados", title = "Nº de disparos bloqueados por jornada / Año") + theme(plot.title = element_text(hjust = 0.5))
ggplot(corners_year_jorn, aes(x = jornada, y = total_corners)) + geom_point() + facet_grid(~year) + labs(x = "jornadas", y = "Nº de corners", title = "Nº de corners por jornada / Año") + theme(plot.title = element_text(hjust = 0.5))
ggplot(centros_year_jorn, aes(x = jornada, y = total_throw_ins)) + geom_point() + facet_grid(~year) + labs(x = "jornadas", y = "Nº de centros", title = "Nº de centros por jornada / Año") + theme(plot.title = element_text(hjust = 0.5))
ggplot(pases_year_jorn, aes(x = jornada, y = total_pass_succ)) + geom_point() + facet_grid(~year) + labs(x = "jornadas", y = "Nº de pases", title = "Nº de pases por jornada / Año") + theme(plot.title = element_text(hjust = 0.5))
ggplot(d_aer_year_jorn, aes(x = jornada, y = total_d_aer)) + geom_point() + facet_grid(~year) + labs(x = "jornadas", y = "Nº de duelos aéreos", title = "Nº de duelos aéreos por jornada / Año") + theme(plot.title = element_text(hjust = 0.5))
ggplot(t_despj_year_jorn, aes(x = jornada, y = total_clearances)) + geom_point() + facet_grid(~year) + labs(x = "jornadas", y = "Nº de despejes", title = "Nº de despejes por jornada / Año") + theme(plot.title = element_text(hjust = 0.5))
ggplot(faltas_year_jorn, aes(x = jornada, y = total_fouls)) + geom_point() + facet_grid(~year) + labs(x = "jornadas", y = "Nº de faltas", title = "Nº de faltas por jornada / Año") + theme(plot.title = element_text(hjust = 0.5))
ggplot(amarll_year_jorn, aes(x = jornada, y = total_yellow_cards)) + geom_point() + facet_grid(~year) + labs(x = "jornadas", y = "Nº de tarj. Amarillas", title = "Nº de tarj. Amarillas por jornada / Año") + theme(plot.title = element_text(hjust = 0.5))
ggplot(rojas_year_jorn, aes(x = jornada, y = total_red_cards)) + geom_point() + facet_grid(~year) + labs(x = "jornadas", y = "Nº de tarj. Rojas", title = "Nº de tarj. Rojas por jornada / Año") + theme(plot.title = element_text(hjust = 0.5))
4.3 MULTIVARIANTE
train %>% select("score", "goals", "jornada", "total_fouls", "total_yellow_cards", "total_red_cards") %>% ggpairs(aes(color = score, alpha = .5))
train %>% select("score", "goals", "total_shots","total_blocked_shots", "total_corners", "total_throw_ins", "total_pass_success", "total_aerials_won", "total_clearances") %>% ggpairs(aes(color = score, alpha = .5))
Media de goles por partido con victoria local
sum(Victorias_casa$Home_Team_Goals_Scored,Victorias_casa$Away_Team_Goals_Scored)/nrow(Victorias_casa)## [1] 2.980114
Media de goles por partido con victoria visitante
sum(Derrotas_casa$Home_Team_Goals_Scored,Derrotas_casa$Away_Team_Goals_Scored)/nrow(Derrotas_casa)## [1] 2.826421
Media de goles por partido con empate
sum(Empates$Home_Team_Goals_Scored,Empates$Away_Team_Goals_Scored)/nrow(Empates)## [1] 1.975567
Puntos promedio por partido por equipo
puntos_promedio_casa <- aggregate((home_points) ~ Home_Team, data = train, mean)
puntos_promedio_fuera <- aggregate(away_points ~ Away_Team, data = train, mean)
puntos_promedio <- data.frame(puntos_promedio_casa$Home_Team, (puntos_promedio_casa$`(home_points)` + puntos_promedio_fuera$away_points)/2)
names(puntos_promedio) <- c("Equipo", "Puntos_por_partido")
puntos_promedio## Equipo Puntos_por_partido
## 1 ALAVÉS 1.2565789
## 2 ALMERÍA 0.8421053
## 3 ATHLETIC 1.4342105
## 4 ATLETICO MADRID 2.0570175
## 5 BARCELONA 2.3552632
## 6 CELTA 1.2412281
## 7 CÓRDOBA 0.5263158
## 8 DEPORTIVO 0.9342105
## 9 EIBAR 1.1929825
## 10 ELCHE 1.0789474
## 11 ESPANYOL 1.2061404
## 12 GETAFE 1.2684211
## 13 GIJÓN 0.9210526
## 14 GIRONA 1.1578947
## 15 GRANADA 0.9868421
## 16 HUESCA 0.8684211
## 17 LAS PALMAS 0.9210526
## 18 LEGANÉS 1.0460526
## 19 LEVANTE 1.0947368
## 20 MÁLAGA 1.0789474
## 21 MALLORCA 0.8684211
## 22 OSASUNA 0.9736842
## 23 RAYO VALLECANO 1.0438596
## 24 REAL BETIS 1.2368421
## 25 REAL MADRID 2.2192982
## 26 REAL SOCIEDAD 1.3728070
## 27 SEVILLA FC 1.6973684
## 28 VALENCIA 1.5526316
## 29 VALLADOLID 1.0921053
## 30 VILLARREAL 1.5614035
Esta seria la clasificación con la media de puntos por partido por equipo
clasificacion_media <- arrange(puntos_promedio,desc(Puntos_por_partido))
clasificacion_media## Equipo Puntos_por_partido
## 1 BARCELONA 2.3552632
## 2 REAL MADRID 2.2192982
## 3 ATLETICO MADRID 2.0570175
## 4 SEVILLA FC 1.6973684
## 5 VILLARREAL 1.5614035
## 6 VALENCIA 1.5526316
## 7 ATHLETIC 1.4342105
## 8 REAL SOCIEDAD 1.3728070
## 9 GETAFE 1.2684211
## 10 ALAVÉS 1.2565789
## 11 CELTA 1.2412281
## 12 REAL BETIS 1.2368421
## 13 ESPANYOL 1.2061404
## 14 EIBAR 1.1929825
## 15 GIRONA 1.1578947
## 16 LEVANTE 1.0947368
## 17 VALLADOLID 1.0921053
## 18 ELCHE 1.0789474
## 19 MÁLAGA 1.0789474
## 20 LEGANÉS 1.0460526
## 21 RAYO VALLECANO 1.0438596
## 22 GRANADA 0.9868421
## 23 OSASUNA 0.9736842
## 24 DEPORTIVO 0.9342105
## 25 GIJÓN 0.9210526
## 26 LAS PALMAS 0.9210526
## 27 HUESCA 0.8684211
## 28 MALLORCA 0.8684211
## 29 ALMERÍA 0.8421053
## 30 CÓRDOBA 0.5263158
aggregate(Home_Team_Goals_Scored ~ Home_Team, data = train, FUN = mean) -> goles_home_team
goles_home_team## Home_Team Home_Team_Goals_Scored
## 1 ALAVÉS 1.0394737
## 2 ALMERÍA 1.0526316
## 3 ATHLETIC 1.4473684
## 4 ATLETICO MADRID 1.7982456
## 5 BARCELONA 3.0789474
## 6 CELTA 1.5438596
## 7 CÓRDOBA 0.6315789
## 8 DEPORTIVO 1.2631579
## 9 EIBAR 1.3771930
## 10 ELCHE 1.0000000
## 11 ESPANYOL 1.1929825
## 12 GETAFE 1.2421053
## 13 GIJÓN 1.4210526
## 14 GIRONA 1.1315789
## 15 GRANADA 1.0789474
## 16 HUESCA 1.2631579
## 17 LAS PALMAS 1.2807018
## 18 LEGANÉS 1.0131579
## 19 LEVANTE 1.3578947
## 20 MÁLAGA 1.2894737
## 21 MALLORCA 1.3157895
## 22 OSASUNA 1.2894737
## 23 RAYO VALLECANO 1.4035088
## 24 REAL BETIS 1.4000000
## 25 REAL MADRID 2.7105263
## 26 REAL SOCIEDAD 1.6140351
## 27 SEVILLA FC 1.8508772
## 28 VALENCIA 1.6491228
## 29 VALLADOLID 0.8947368
## 30 VILLARREAL 1.6666667aggregate(Away_Team_Goals_Scored ~ Away_Team, data = train, FUN = mean) -> goles_Away_team
goles_Away_team## Away_Team Away_Team_Goals_Scored
## 1 ALAVÉS 0.9868421
## 2 ALMERÍA 0.7894737
## 3 ATHLETIC 0.9736842
## 4 ATLETICO MADRID 1.3947368
## 5 BARCELONA 2.2982456
## 6 CELTA 1.0877193
## 7 CÓRDOBA 0.5263158
## 8 DEPORTIVO 0.8552632
## 9 EIBAR 0.9736842
## 10 ELCHE 0.8421053
## 11 ESPANYOL 0.9736842
## 12 GETAFE 0.8947368
## 13 GIJÓN 0.7368421
## 14 GIRONA 1.1578947
## 15 GRANADA 0.9868421
## 16 HUESCA 1.0000000
## 17 LAS PALMAS 0.8596491
## 18 LEGANÉS 0.7894737
## 19 LEVANTE 0.9684211
## 20 MÁLAGA 0.7236842
## 21 MALLORCA 0.7894737
## 22 OSASUNA 0.9736842
## 23 RAYO VALLECANO 1.0350877
## 24 REAL BETIS 0.9894737
## 25 REAL MADRID 2.2105263
## 26 REAL SOCIEDAD 1.1491228
## 27 SEVILLA FC 1.2719298
## 28 VALENCIA 1.2807018
## 29 VALLADOLID 0.7894737
## 30 VILLARREAL 1.1140351goles_por_equipo <- data.frame(goles_home_team$Home_Team,(goles_Away_team$Away_Team_Goals_Scored + goles_home_team$Home_Team_Goals_Scored)/2)
names(goles_por_equipo) <- c("equipo", "goals")
goles_por_equipo## equipo goals
## 1 ALAVÉS 1.0131579
## 2 ALMERÍA 0.9210526
## 3 ATHLETIC 1.2105263
## 4 ATLETICO MADRID 1.5964912
## 5 BARCELONA 2.6885965
## 6 CELTA 1.3157895
## 7 CÓRDOBA 0.5789474
## 8 DEPORTIVO 1.0592105
## 9 EIBAR 1.1754386
## 10 ELCHE 0.9210526
## 11 ESPANYOL 1.0833333
## 12 GETAFE 1.0684211
## 13 GIJÓN 1.0789474
## 14 GIRONA 1.1447368
## 15 GRANADA 1.0328947
## 16 HUESCA 1.1315789
## 17 LAS PALMAS 1.0701754
## 18 LEGANÉS 0.9013158
## 19 LEVANTE 1.1631579
## 20 MÁLAGA 1.0065789
## 21 MALLORCA 1.0526316
## 22 OSASUNA 1.1315789
## 23 RAYO VALLECANO 1.2192982
## 24 REAL BETIS 1.1947368
## 25 REAL MADRID 2.4605263
## 26 REAL SOCIEDAD 1.3815789
## 27 SEVILLA FC 1.5614035
## 28 VALENCIA 1.4649123
## 29 VALLADOLID 0.8421053
## 30 VILLARREAL 1.3903509
#No he sido capaz de poner encima una grafica de densidad con los puntos de cada equipo
ggplot(goles_por_equipo, aes(x = equipo, y = goals)) + geom_bar(position = "dodge", stat = "summary", fill = "darkred") + labs(title = "Comparación goles y puntos") + theme(plot.title = element_text(hjust = 0.5), axis.text.x = element_text(angle = 90))
Porcentaje medio de posesión por equipo en casa
tapply(train$`Home_Team_Possession_%`,train$`Home_Team`,mean)## ALAVÉS ALMERÍA ATHLETIC ATLETICO MADRID BARCELONA
## 43.86842 45.42105 51.60526 50.35965 66.31579
## CÁDIZ CF CELTA CÓRDOBA DEPORTIVO EIBAR
## NA 56.37719 51.47368 49.11842 50.61404
## ELCHE ESPANYOL GETAFE GIJÓN GIRONA
## 50.05263 48.02632 44.64211 45.89474 49.52632
## GRANADA HUESCA LAS PALMAS LEGANÉS LEVANTE
## 46.69737 47.31579 58.73684 45.60526 46.25263
## MÁLAGA MALLORCA OSASUNA RAYO VALLECANO REAL BETIS
## 48.85526 42.89474 45.47368 54.57895 55.57895
## REAL MADRID REAL SOCIEDAD SEVILLA FC VALENCIA VALLADOLID
## 60.01754 55.49123 56.39474 49.71930 47.60526
## VILLARREAL
## 51.55263
Porcentaje medio de posesión por equipo fuera de casa
tapply(train$`Away_Team_Possession_%`,train$`Away_Team`,mean)## ALAVÉS ALMERÍA ATHLETIC ATLETICO MADRID BARCELONA
## 39.93421 42.31579 48.71930 46.68421 66.14035
## CÁDIZ CF CELTA CÓRDOBA DEPORTIVO EIBAR
## NA 52.42105 41.21053 45.23684 45.45614
## ELCHE ESPANYOL GETAFE GIJÓN GIRONA
## 44.89474 44.92105 41.80000 41.42105 45.44737
## GRANADA HUESCA LAS PALMAS LEGANÉS LEVANTE
## 42.86842 41.21053 53.70175 41.26316 43.56842
## MÁLAGA MALLORCA OSASUNA RAYO VALLECANO REAL BETIS
## 46.07895 46.15789 40.94737 53.59649 53.07368
## REAL MADRID REAL SOCIEDAD SEVILLA FC VALENCIA VALLADOLID
## 57.20175 52.43860 51.73684 48.09649 43.36842
## VILLARREAL
## 46.90351
Con estos datos tan similares sacamos en conclusión que la posesión no ha influido mucho en las victorias(pobre Pep)
summary(Empates$`Home_Team_Possession_%`)## Min. 1st Qu. Median Mean 3rd Qu. Max.
## 21.00 45.00 52.00 51.69 59.00 81.00summary(Victorias_casa$`Home_Team_Possession_%`)## Min. 1st Qu. Median Mean 3rd Qu. Max.
## 22.00 44.00 52.00 52.18 60.00 83.00summary(Derrotas_casa$`Home_Team_Possession_%`)## Min. 1st Qu. Median Mean 3rd Qu. Max.
## 19.00 43.00 52.00 50.86 59.00 80.00
Media de goles por partido de cada equipo en su casa
ggplot(train,aes(Home_Team ,Home_Team_Goals_Scored)) + geom_bar(position = "dodge", stat = "summary", fun = "mean", color = 'black', fill = 'red') + labs(title="media de goles de cada equipo como local", x="equipos", y="goles por partido") + theme(plot.title=element_text(hjust = 0.5), axis.text = element_text(angle = 90, color = "darkblue"))
Los equipos que más goles meten por partido, son los que más temporadas han estado en primera
ggplot(train,aes(Away_Team ,Away_Team_Goals_Scored)) + geom_bar(position = "dodge", stat = "summary", fun = "mean", color = 'black', fill = 'red') + labs(title="media de goles de cada equipo como visitante", x="equipos", y="goles por partido") + theme(plot.title=element_text(hjust = 0.5), axis.text = element_text(angle = 90, color = "darkblue"))
Correlación de algunas variables
pairs(train %>% select(Home_Team_Goals_Scored, Home_Team_On_Target_Shots, Home_Team_Total_Shots, `Home_Team_Possession_%`, `Home_Team_Pass_Success_%`, Home_Team_Corners, Home_Team_Throw_Ins, Home_Team_Fouls, Home_Team_Aerials_Won), pch = 21, bg = "black", col = "red")
# Esto lo borraría
hist(train$Home_Team_Goals_Scored,breaks=15, main = "Histograma de goles en casa", xlab = "goles")
# Esto lo borraría
hist(train$Away_Team_Goals_Scored,breaks=15, main = "Histograma de goles fuera",
xlab = "goles")
# Se marcan más goles en casa que fuera
En un 30% de las victorias de casa el equipo de casa tiró menos tiros que el de fuera
prop.table(table(Victorias_casa$Home_Team_Total_Shots > Victorias_casa$Away_Team_Total_Shots))##
## FALSE TRUE
## 0.3001894 0.6998106
Los tiros bloqueados no influyen mucho en el resultado del partido
prop.table(table(Victorias_casa$Home_Team_Blocked_Shots > Victorias_casa$Away_Team_Blocked_Shots))##
## FALSE TRUE
## 0.5246212 0.4753788
En las derrotas si vemos que el 43% de las veces bloquearon menos
prop.table(table(Derrotas_casa$Home_Team_Blocked_Shots > Derrotas_casa$Away_Team_Blocked_Shots))##
## FALSE TRUE
## 0.437788 0.562212
5 REGRESION
# esta la borraría y me centraría en las principales, en las totales. Las que va a continuación.
lm_fit <- lm(Home_Team_Goals_Scored~.-Home_Team, data=train)
summary(lm_fit)##
## Call:
## lm(formula = Home_Team_Goals_Scored ~ . - Home_Team, data = train)
##
## Residuals:
## Min 1Q Median 3Q Max
## -4.042e-13 -1.170e-15 -8.000e-17 1.150e-15 3.475e-14
##
## Coefficients: (16 not defined because of singularities)
## Estimate Std. Error t value Pr(>|t|)
## (Intercept) 1.208e-10 5.608e-11 2.154e+00 0.031384 *
## ...1 1.587e-16 7.326e-17 2.166e+00 0.030398 *
## Away_TeamALMERÍA 5.513e-16 2.584e-15 2.130e-01 0.831092
## Away_TeamATHLETIC -4.461e-15 1.488e-15 -2.998e+00 0.002749 **
## Away_TeamATLETICO MADRID -3.306e-15 1.506e-15 -2.195e+00 0.028284 *
## Away_TeamBARCELONA -9.209e-16 1.711e-15 -5.380e-01 0.590435
## Away_TeamCELTA -2.993e-17 1.511e-15 -2.000e-02 0.984201
## Away_TeamCÓRDOBA 3.174e-15 2.582e-15 1.229e+00 0.219181
## Away_TeamDEPORTIVO -8.002e-16 1.645e-15 -4.860e-01 0.626722
## Away_TeamEIBAR -1.266e-15 1.502e-15 -8.430e-01 0.399321
## Away_TeamELCHE 2.124e-16 2.585e-15 8.200e-02 0.934510
## Away_TeamESPANYOL -6.233e-16 1.477e-15 -4.220e-01 0.673148
## Away_TeamGETAFE -1.369e-15 1.551e-15 -8.830e-01 0.377536
## Away_TeamGIJÓN 8.603e-17 1.994e-15 4.300e-02 0.965593
## Away_TeamGIRONA 1.598e-15 1.974e-15 8.100e-01 0.418309
## Away_TeamGRANADA 6.182e-16 1.623e-15 3.810e-01 0.703358
## Away_TeamHUESCA 2.797e-16 2.529e-15 1.110e-01 0.911938
## Away_TeamLAS PALMAS -2.570e-16 1.813e-15 -1.420e-01 0.887298
## Away_TeamLEGANÉS -4.246e-15 1.608e-15 -2.640e+00 0.008349 **
## Away_TeamLEVANTE 1.868e-15 1.533e-15 1.218e+00 0.223247
## Away_TeamMÁLAGA -1.467e-15 1.638e-15 -8.960e-01 0.370557
## Away_TeamMALLORCA 4.409e-16 2.548e-15 1.730e-01 0.862654
## Away_TeamOSASUNA -1.836e-16 1.971e-15 -9.300e-02 0.925771
## Away_TeamRAYO VALLECANO -2.471e-16 1.798e-15 -1.370e-01 0.890665
## Away_TeamREAL BETIS 1.559e-15 1.583e-15 9.850e-01 0.324963
## Away_TeamREAL MADRID -6.222e-15 1.616e-15 -3.851e+00 0.000121 ***
## Away_TeamREAL SOCIEDAD -4.296e-16 1.506e-15 -2.850e-01 0.775516
## Away_TeamSEVILLA FC 1.821e-16 1.509e-15 1.210e-01 0.903962
## Away_TeamVALENCIA -1.830e-15 1.504e-15 -1.217e+00 0.223777
## Away_TeamVALLADOLID 1.826e-15 1.978e-15 9.230e-01 0.355960
## Away_TeamVILLARREAL -8.719e-16 1.503e-15 -5.800e-01 0.561848
## `Home_Team_Possession_%` 3.081e-17 6.976e-17 4.420e-01 0.658818
## `Away_Team_Possession_%` NA NA NA NA
## Home_Team_Off_Target_Shots 5.594e-16 1.153e-15 4.850e-01 0.627723
## Home_Team_On_Target_Shots -8.808e-16 1.154e-15 -7.630e-01 0.445286
## Home_Team_Total_Shots -5.364e-16 1.148e-15 -4.670e-01 0.640467
## Home_Team_Blocked_Shots 4.946e-16 1.150e-15 4.300e-01 0.667220
## Home_Team_Corners 3.861e-16 9.413e-17 4.102e+00 4.25e-05 ***
## Home_Team_Throw_Ins 9.759e-17 4.050e-17 2.409e+00 0.016067 *
## `Home_Team_Pass_Success_%` 1.095e-16 7.580e-17 1.445e+00 0.148627
## Home_Team_Aerials_Won -4.737e-17 4.061e-17 -1.167e+00 0.243509
## Home_Team_Clearances 1.124e-16 3.650e-17 3.080e+00 0.002095 **
## Home_Team_Fouls 8.635e-17 5.946e-17 1.452e+00 0.146575
## Home_Team_Yellow_Cards -2.207e-17 1.545e-16 -1.430e-01 0.886379
## Home_Team_Second_Yellow_Cards -1.278e-15 8.831e-16 -1.448e+00 0.147880
## Home_Team_Red_Cards -1.051e-14 9.535e-16 -1.103e+01 < 2e-16 ***
## Away_Team_Off_Target_Shots 9.210e-16 9.942e-16 9.260e-01 0.354392
## Away_Team_On_Target_Shots 3.846e-16 9.983e-16 3.850e-01 0.700115
## Away_Team_Total_Shots -7.232e-16 9.907e-16 -7.300e-01 0.465520
## Away_Team_Blocked_Shots 8.486e-16 9.988e-16 8.500e-01 0.395643
## Away_Team_Corners 1.003e-16 1.036e-16 9.680e-01 0.332978
## Away_Team_Throw_Ins 1.858e-17 4.297e-17 4.320e-01 0.665444
## `Away_Team_Pass_Success_%` -4.175e-17 7.289e-17 -5.730e-01 0.566855
## Away_Team_Aerials_Won -8.280e-18 4.214e-17 -1.960e-01 0.844256
## Away_Team_Clearances 2.098e-18 3.263e-17 6.400e-02 0.948740
## Away_Team_Fouls 7.512e-17 5.826e-17 1.289e+00 0.197397
## Away_Team_Yellow_Cards 1.652e-16 1.561e-16 1.058e+00 0.290015
## Away_Team_Second_Yellow_Cards 8.676e-16 7.582e-16 1.144e+00 0.252623
## Away_Team_Red_Cards 1.252e-15 9.402e-16 1.332e+00 0.182992
## Away_Team_Goals_Scored -1.000e+00 4.808e-16 -2.080e+15 < 2e-16 ***
## year -5.997e-14 2.784e-14 -2.154e+00 0.031352 *
## scorex 1.183e-16 6.784e-16 1.740e-01 0.861608
## score2 1.670e-15 9.607e-16 1.738e+00 0.082304 .
## goals 1.000e+00 2.693e-16 3.713e+15 < 2e-16 ***
## home_points NA NA NA NA
## away_points NA NA NA NA
## jornada -1.518e-15 7.328e-16 -2.072e+00 0.038411 *
## total_off_target_shots NA NA NA NA
## total_on_target_shots NA NA NA NA
## total_shots NA NA NA NA
## total_blocked_shots NA NA NA NA
## total_corners NA NA NA NA
## total_throw_ins NA NA NA NA
## total_pass_success NA NA NA NA
## total_aerials_won NA NA NA NA
## total_clearances NA NA NA NA
## total_fouls NA NA NA NA
## total_yellow_cards NA NA NA NA
## total_second_yellow_cards NA NA NA NA
## total_red_cards NA NA NA NA
## ---
## Signif. codes: 0 '***' 0.001 '**' 0.01 '*' 0.05 '.' 0.1 ' ' 1
##
## Residual standard error: 9.799e-15 on 2216 degrees of freedom
## Multiple R-squared: 1, Adjusted R-squared: 1
## F-statistic: 6.757e+29 on 63 and 2216 DF, p-value: < 2.2e-16#regfit_fwd <- leaps::regsubsets(Home_Team_Goals_Scored~., train, method="forward")
#for (metric in c("r2", "adjr2", "Cp", "bic")){plot(regfit_fwd, scale=metric)}Variables más influyentes en los goles marcados: Centros, despejes,
tarjetas rojas,
Regresión con todas las variables
lm_goles <- lm(goals~., data = train)
summary(lm_goles)##
## Call:
## lm(formula = goals ~ ., data = train)
##
## Residuals:
## Min 1Q Median 3Q Max
## -4.252e-14 -1.180e-15 1.100e-16 1.310e-15 3.978e-13
##
## Coefficients: (16 not defined because of singularities)
## Estimate Std. Error t value Pr(>|t|)
## (Intercept) -1.037e-10 5.655e-11 -1.834e+00 0.066848 .
## ...1 -1.363e-16 7.388e-17 -1.846e+00 0.065091 .
## Home_TeamALMERÍA -9.591e-16 2.590e-15 -3.700e-01 0.711142
## Home_TeamATHLETIC -3.738e-16 1.497e-15 -2.500e-01 0.802835
## Home_TeamATLETICO MADRID 3.007e-16 1.515e-15 1.990e-01 0.842660
## Home_TeamBARCELONA -2.144e-15 1.760e-15 -1.218e+00 0.223285
## Home_TeamCELTA -9.547e-16 1.542e-15 -6.190e-01 0.535914
## Home_TeamCÓRDOBA -2.002e-15 2.592e-15 -7.720e-01 0.439992
## Home_TeamDEPORTIVO 7.998e-16 1.645e-15 4.860e-01 0.626772
## Home_TeamEIBAR -4.925e-16 1.526e-15 -3.230e-01 0.746983
## Home_TeamELCHE -2.960e-15 2.597e-15 -1.140e+00 0.254555
## Home_TeamESPANYOL -2.478e-15 1.482e-15 -1.672e+00 0.094599 .
## Home_TeamGETAFE -2.851e-15 1.560e-15 -1.827e+00 0.067830 .
## Home_TeamGIJÓN -4.155e-15 2.014e-15 -2.063e+00 0.039226 *
## Home_TeamGIRONA -5.397e-16 1.980e-15 -2.730e-01 0.785226
## Home_TeamGRANADA -9.466e-16 1.625e-15 -5.820e-01 0.560375
## Home_TeamHUESCA 1.180e-15 2.545e-15 4.640e-01 0.642900
## Home_TeamLAS PALMAS -5.480e-15 1.855e-15 -2.954e+00 0.003171 **
## Home_TeamLEGANÉS -1.753e-15 1.611e-15 -1.089e+00 0.276446
## Home_TeamLEVANTE -1.458e-15 1.546e-15 -9.430e-01 0.345638
## Home_TeamMÁLAGA 5.077e-15 1.641e-15 3.094e+00 0.002002 **
## Home_TeamMALLORCA -1.474e-15 2.555e-15 -5.770e-01 0.564009
## Home_TeamOSASUNA -3.709e-16 1.991e-15 -1.860e-01 0.852266
## Home_TeamRAYO VALLECANO -4.176e-15 1.805e-15 -2.314e+00 0.020782 *
## Home_TeamREAL BETIS -2.062e-15 1.598e-15 -1.290e+00 0.197184
## Home_TeamREAL MADRID -1.046e-15 1.673e-15 -6.250e-01 0.532040
## Home_TeamREAL SOCIEDAD 3.737e-16 1.526e-15 2.450e-01 0.806617
## Home_TeamSEVILLA FC -1.665e-16 1.550e-15 -1.070e-01 0.914460
## Home_TeamVALENCIA -1.680e-16 1.521e-15 -1.110e-01 0.912015
## Home_TeamVALLADOLID 1.864e-15 1.993e-15 9.350e-01 0.349727
## Home_TeamVILLARREAL -1.648e-15 1.522e-15 -1.083e+00 0.278961
## Away_TeamALMERÍA 9.205e-15 2.588e-15 3.557e+00 0.000383 ***
## Away_TeamATHLETIC 3.958e-15 1.498e-15 2.642e+00 0.008308 **
## Away_TeamATLETICO MADRID -8.607e-16 1.516e-15 -5.680e-01 0.570196
## Away_TeamBARCELONA 5.579e-16 1.768e-15 3.160e-01 0.752331
## Away_TeamCELTA 6.818e-16 1.523e-15 4.480e-01 0.654362
## Away_TeamCÓRDOBA 4.133e-16 2.589e-15 1.600e-01 0.873206
## Away_TeamDEPORTIVO 1.370e-15 1.650e-15 8.310e-01 0.406202
## Away_TeamEIBAR 2.817e-15 1.513e-15 1.862e+00 0.062729 .
## Away_TeamELCHE -2.987e-15 2.589e-15 -1.154e+00 0.248629
## Away_TeamESPANYOL 1.309e-15 1.481e-15 8.840e-01 0.376749
## Away_TeamGETAFE 3.797e-16 1.557e-15 2.440e-01 0.807336
## Away_TeamGIJÓN 3.729e-16 1.996e-15 1.870e-01 0.851829
## Away_TeamGIRONA 2.581e-16 1.978e-15 1.300e-01 0.896183
## Away_TeamGRANADA 1.627e-15 1.625e-15 1.001e+00 0.316792
## Away_TeamHUESCA -5.483e-16 2.532e-15 -2.170e-01 0.828593
## Away_TeamLAS PALMAS 4.558e-15 1.825e-15 2.497e+00 0.012588 *
## Away_TeamLEGANÉS -7.124e-16 1.610e-15 -4.420e-01 0.658262
## Away_TeamLEVANTE 2.478e-15 1.536e-15 1.613e+00 0.106850
## Away_TeamMÁLAGA -7.302e-16 1.643e-15 -4.440e-01 0.656785
## Away_TeamMALLORCA 4.265e-15 2.552e-15 1.671e+00 0.094851 .
## Away_TeamOSASUNA -9.294e-16 1.974e-15 -4.710e-01 0.637826
## Away_TeamRAYO VALLECANO 3.447e-15 1.807e-15 1.908e+00 0.056577 .
## Away_TeamREAL BETIS 2.295e-15 1.596e-15 1.438e+00 0.150706
## Away_TeamREAL MADRID 2.442e-15 1.648e-15 1.482e+00 0.138554
## Away_TeamREAL SOCIEDAD 2.615e-15 1.521e-15 1.719e+00 0.085709 .
## Away_TeamSEVILLA FC 2.029e-15 1.521e-15 1.334e+00 0.182380
## Away_TeamVALENCIA 2.030e-15 1.512e-15 1.343e+00 0.179491
## Away_TeamVALLADOLID 8.160e-16 1.979e-15 4.120e-01 0.680191
## Away_TeamVILLARREAL 2.426e-15 1.511e-15 1.606e+00 0.108421
## `Home_Team_Possession_%` 2.661e-16 7.675e-17 3.467e+00 0.000537 ***
## `Away_Team_Possession_%` NA NA NA NA
## Home_Team_Off_Target_Shots -5.490e-17 1.160e-15 -4.700e-02 0.962264
## Home_Team_On_Target_Shots 8.129e-16 1.160e-15 7.010e-01 0.483655
## Home_Team_Total_Shots 1.966e-16 1.155e-15 1.700e-01 0.864902
## Home_Team_Blocked_Shots -4.294e-16 1.157e-15 -3.710e-01 0.710587
## Home_Team_Corners -1.787e-16 9.541e-17 -1.873e+00 0.061268 .
## Home_Team_Throw_Ins 1.039e-16 4.171e-17 2.490e+00 0.012842 *
## `Home_Team_Pass_Success_%` -1.984e-16 8.174e-17 -2.428e+00 0.015282 *
## Home_Team_Aerials_Won 1.748e-18 4.342e-17 4.000e-02 0.967898
## Home_Team_Clearances -7.912e-17 3.698e-17 -2.139e+00 0.032523 *
## Home_Team_Fouls -4.362e-17 6.077e-17 -7.180e-01 0.472930
## Home_Team_Yellow_Cards 4.599e-17 1.560e-16 2.950e-01 0.768092
## Home_Team_Second_Yellow_Cards 6.128e-17 8.899e-16 6.900e-02 0.945103
## Home_Team_Red_Cards 6.101e-15 9.652e-16 6.321e+00 3.14e-10 ***
## Away_Team_Off_Target_Shots 5.597e-16 9.965e-16 5.620e-01 0.574360
## Away_Team_On_Target_Shots 1.487e-15 1.001e-15 1.486e+00 0.137365
## Away_Team_Total_Shots -6.901e-16 9.931e-16 -6.950e-01 0.487226
## Away_Team_Blocked_Shots 6.828e-16 1.001e-15 6.820e-01 0.495242
## Away_Team_Corners -6.942e-17 1.044e-16 -6.650e-01 0.506168
## Away_Team_Throw_Ins 4.391e-18 4.458e-17 9.800e-02 0.921561
## `Away_Team_Pass_Success_%` 1.144e-16 7.615e-17 1.502e+00 0.133206
## Away_Team_Aerials_Won 2.425e-17 4.290e-17 5.650e-01 0.571987
## Away_Team_Clearances -2.391e-16 3.404e-17 -7.023e+00 2.90e-12 ***
## Away_Team_Fouls -1.750e-16 6.009e-17 -2.913e+00 0.003616 **
## Away_Team_Yellow_Cards 1.858e-16 1.586e-16 1.171e+00 0.241533
## Away_Team_Second_Yellow_Cards 4.049e-16 7.679e-16 5.270e-01 0.598062
## Away_Team_Red_Cards -3.413e-16 9.455e-16 -3.610e-01 0.718154
## Home_Team_Goals_Scored 1.000e+00 2.730e-16 3.663e+15 < 2e-16 ***
## Away_Team_Goals_Scored 1.000e+00 3.085e-16 3.242e+15 < 2e-16 ***
## year 5.149e-14 2.808e-14 1.834e+00 0.066819 .
## scorex -6.430e-16 6.855e-16 -9.380e-01 0.348277
## score2 -1.171e-15 9.729e-16 -1.204e+00 0.228794
## home_points NA NA NA NA
## away_points NA NA NA NA
## jornada 1.324e-15 7.390e-16 1.792e+00 0.073343 .
## total_off_target_shots NA NA NA NA
## total_on_target_shots NA NA NA NA
## total_shots NA NA NA NA
## total_blocked_shots NA NA NA NA
## total_corners NA NA NA NA
## total_throw_ins NA NA NA NA
## total_pass_success NA NA NA NA
## total_aerials_won NA NA NA NA
## total_clearances NA NA NA NA
## total_fouls NA NA NA NA
## total_yellow_cards NA NA NA NA
## total_second_yellow_cards NA NA NA NA
## total_red_cards NA NA NA NA
## ---
## Signif. codes: 0 '***' 0.001 '**' 0.01 '*' 0.05 '.' 0.1 ' ' 1
##
## Residual standard error: 9.794e-15 on 2187 degrees of freedom
## Multiple R-squared: 1, Adjusted R-squared: 1
## F-statistic: 7.5e+29 on 92 and 2187 DF, p-value: < 2.2e-16lm_disparos <- lm(total_shots~., data = train)
summary(lm_disparos)##
## Call:
## lm(formula = total_shots ~ ., data = train)
##
## Residuals:
## Min 1Q Median 3Q Max
## -2.785e-13 -1.070e-14 4.200e-15 1.890e-14 6.871e-12
##
## Coefficients: (16 not defined because of singularities)
## Estimate Std. Error t value Pr(>|t|)
## (Intercept) -1.903e-09 8.797e-10 -2.164e+00 0.03061 *
## ...1 -2.497e-15 1.149e-15 -2.173e+00 0.02989 *
## Home_TeamALMERÍA -2.646e-14 4.029e-14 -6.570e-01 0.51138
## Home_TeamATHLETIC -2.397e-15 2.329e-14 -1.030e-01 0.91805
## Home_TeamATLETICO MADRID -8.469e-15 2.357e-14 -3.590e-01 0.71934
## Home_TeamBARCELONA -2.508e-14 2.738e-14 -9.160e-01 0.35977
## Home_TeamCELTA -7.377e-15 2.399e-14 -3.080e-01 0.75847
## Home_TeamCÓRDOBA -8.556e-16 4.032e-14 -2.100e-02 0.98307
## Home_TeamDEPORTIVO -4.844e-15 2.558e-14 -1.890e-01 0.84986
## Home_TeamEIBAR -9.743e-15 2.374e-14 -4.100e-01 0.68160
## Home_TeamELCHE -1.443e-14 4.040e-14 -3.570e-01 0.72109
## Home_TeamESPANYOL -3.681e-16 2.305e-14 -1.600e-02 0.98726
## Home_TeamGETAFE -1.341e-14 2.427e-14 -5.520e-01 0.58072
## Home_TeamGIJÓN -2.070e-14 3.133e-14 -6.610e-01 0.50891
## Home_TeamGIRONA 1.272e-15 3.080e-14 4.100e-02 0.96707
## Home_TeamGRANADA -1.049e-14 2.529e-14 -4.150e-01 0.67818
## Home_TeamHUESCA -3.849e-15 3.960e-14 -9.700e-02 0.92257
## Home_TeamLAS PALMAS -5.839e-15 2.886e-14 -2.020e-01 0.83967
## Home_TeamLEGANÉS -1.105e-14 2.506e-14 -4.410e-01 0.65937
## Home_TeamLEVANTE -1.694e-14 2.405e-14 -7.040e-01 0.48142
## Home_TeamMÁLAGA 7.941e-14 2.553e-14 3.111e+00 0.00189 **
## Home_TeamMALLORCA -4.440e-18 3.974e-14 0.000e+00 0.99991
## Home_TeamOSASUNA -5.090e-15 3.098e-14 -1.640e-01 0.86951
## Home_TeamRAYO VALLECANO -1.262e-14 2.808e-14 -4.490e-01 0.65315
## Home_TeamREAL BETIS -3.354e-15 2.487e-14 -1.350e-01 0.89272
## Home_TeamREAL MADRID -1.843e-14 2.603e-14 -7.080e-01 0.47888
## Home_TeamREAL SOCIEDAD -3.037e-15 2.374e-14 -1.280e-01 0.89822
## Home_TeamSEVILLA FC -7.815e-15 2.411e-14 -3.240e-01 0.74582
## Home_TeamVALENCIA -5.715e-15 2.366e-14 -2.420e-01 0.80911
## Home_TeamVALLADOLID 2.032e-15 3.100e-14 6.600e-02 0.94774
## Home_TeamVILLARREAL -6.956e-15 2.368e-14 -2.940e-01 0.76896
## Away_TeamALMERÍA 1.617e-15 4.026e-14 4.000e-02 0.96797
## Away_TeamATHLETIC 5.872e-14 2.331e-14 2.519e+00 0.01184 *
## Away_TeamATLETICO MADRID -1.423e-15 2.358e-14 -6.000e-02 0.95189
## Away_TeamBARCELONA -2.422e-14 2.750e-14 -8.810e-01 0.37858
## Away_TeamCELTA -7.690e-15 2.369e-14 -3.250e-01 0.74546
## Away_TeamCÓRDOBA -1.514e-14 4.028e-14 -3.760e-01 0.70706
## Away_TeamDEPORTIVO -4.149e-15 2.566e-14 -1.620e-01 0.87156
## Away_TeamEIBAR -6.707e-15 2.353e-14 -2.850e-01 0.77567
## Away_TeamELCHE -2.436e-14 4.027e-14 -6.050e-01 0.54529
## Away_TeamESPANYOL -5.490e-15 2.303e-14 -2.380e-01 0.81164
## Away_TeamGETAFE -3.163e-15 2.422e-14 -1.310e-01 0.89612
## Away_TeamGIJÓN 1.061e-15 3.105e-14 3.400e-02 0.97275
## Away_TeamGIRONA -4.658e-15 3.076e-14 -1.510e-01 0.87965
## Away_TeamGRANADA -6.892e-15 2.528e-14 -2.730e-01 0.78515
## Away_TeamHUESCA -2.759e-15 3.939e-14 -7.000e-02 0.94416
## Away_TeamLAS PALMAS -1.222e-14 2.839e-14 -4.300e-01 0.66691
## Away_TeamLEGANÉS -3.420e-15 2.505e-14 -1.370e-01 0.89143
## Away_TeamLEVANTE -1.425e-14 2.389e-14 -5.970e-01 0.55089
## Away_TeamMÁLAGA -6.897e-16 2.556e-14 -2.700e-02 0.97848
## Away_TeamMALLORCA 2.873e-15 3.970e-14 7.200e-02 0.94231
## Away_TeamOSASUNA 9.386e-15 3.071e-14 3.060e-01 0.75990
## Away_TeamRAYO VALLECANO -6.155e-15 2.811e-14 -2.190e-01 0.82669
## Away_TeamREAL BETIS -1.280e-14 2.483e-14 -5.160e-01 0.60616
## Away_TeamREAL MADRID 1.362e-14 2.564e-14 5.310e-01 0.59520
## Away_TeamREAL SOCIEDAD 2.650e-15 2.366e-14 1.120e-01 0.91084
## Away_TeamSEVILLA FC -6.062e-15 2.367e-14 -2.560e-01 0.79789
## Away_TeamVALENCIA -4.382e-15 2.352e-14 -1.860e-01 0.85224
## Away_TeamVALLADOLID -1.185e-14 3.079e-14 -3.850e-01 0.70048
## Away_TeamVILLARREAL -8.914e-15 2.350e-14 -3.790e-01 0.70449
## `Home_Team_Possession_%` 1.559e-15 1.194e-15 1.305e+00 0.19186
## `Away_Team_Possession_%` NA NA NA NA
## Home_Team_Off_Target_Shots -6.887e-16 1.805e-14 -3.800e-02 0.96957
## Home_Team_On_Target_Shots -3.796e-15 1.805e-14 -2.100e-01 0.83345
## Home_Team_Total_Shots 1.000e+00 1.797e-14 5.563e+13 < 2e-16 ***
## Home_Team_Blocked_Shots -4.680e-16 1.800e-14 -2.600e-02 0.97926
## Home_Team_Corners -2.029e-16 1.484e-15 -1.370e-01 0.89126
## Home_Team_Throw_Ins -1.111e-15 6.488e-16 -1.712e+00 0.08697 .
## `Home_Team_Pass_Success_%` -2.275e-15 1.272e-15 -1.789e+00 0.07375 .
## Home_Team_Aerials_Won -2.163e-16 6.754e-16 -3.200e-01 0.74885
## Home_Team_Clearances -3.969e-16 5.753e-16 -6.900e-01 0.49030
## Home_Team_Fouls -7.746e-16 9.454e-16 -8.190e-01 0.41270
## Home_Team_Yellow_Cards 1.138e-15 2.426e-15 4.690e-01 0.63914
## Home_Team_Second_Yellow_Cards 1.409e-15 1.384e-14 1.020e-01 0.91893
## Home_Team_Red_Cards 1.360e-13 1.502e-14 9.060e+00 < 2e-16 ***
## Away_Team_Off_Target_Shots -2.766e-15 1.550e-14 -1.780e-01 0.85839
## Away_Team_On_Target_Shots 2.079e-15 1.557e-14 1.340e-01 0.89375
## Away_Team_Total_Shots 1.000e+00 1.545e-14 6.473e+13 < 2e-16 ***
## Away_Team_Blocked_Shots -8.861e-16 1.557e-14 -5.700e-02 0.95463
## Away_Team_Corners -5.089e-16 1.624e-15 -3.130e-01 0.75405
## Away_Team_Throw_Ins -2.886e-16 6.936e-16 -4.160e-01 0.67738
## `Away_Team_Pass_Success_%` 1.269e-15 1.185e-15 1.072e+00 0.28397
## Away_Team_Aerials_Won 7.110e-17 6.673e-16 1.070e-01 0.91516
## Away_Team_Clearances -4.433e-16 5.296e-16 -8.370e-01 0.40266
## Away_Team_Fouls -1.323e-15 9.348e-16 -1.415e+00 0.15710
## Away_Team_Yellow_Cards 6.105e-16 2.467e-15 2.470e-01 0.80458
## Away_Team_Second_Yellow_Cards -4.817e-15 1.194e-14 -4.030e-01 0.68682
## Away_Team_Red_Cards -1.416e-14 1.471e-14 -9.630e-01 0.33574
## Home_Team_Goals_Scored -3.459e-15 4.247e-15 -8.150e-01 0.41542
## Away_Team_Goals_Scored -3.047e-15 4.799e-15 -6.350e-01 0.52555
## year 9.451e-13 4.368e-13 2.164e+00 0.03059 *
## scorex -1.661e-14 1.066e-14 -1.557e+00 0.11951
## score2 -2.460e-14 1.514e-14 -1.626e+00 0.10420
## goals NA NA NA NA
## home_points NA NA NA NA
## away_points NA NA NA NA
## jornada 2.442e-14 1.150e-14 2.124e+00 0.03377 *
## total_off_target_shots NA NA NA NA
## total_on_target_shots NA NA NA NA
## total_blocked_shots NA NA NA NA
## total_corners NA NA NA NA
## total_throw_ins NA NA NA NA
## total_pass_success NA NA NA NA
## total_aerials_won NA NA NA NA
## total_clearances NA NA NA NA
## total_fouls NA NA NA NA
## total_yellow_cards NA NA NA NA
## total_second_yellow_cards NA NA NA NA
## total_red_cards NA NA NA NA
## ---
## Signif. codes: 0 '***' 0.001 '**' 0.01 '*' 0.05 '.' 0.1 ' ' 1
##
## Residual standard error: 1.524e-13 on 2187 degrees of freedom
## Multiple R-squared: 1, Adjusted R-squared: 1
## F-statistic: 3.438e+28 on 92 and 2187 DF, p-value: < 2.2e-16lm_disparos_bloqueados <- lm(total_blocked_shots~., data = train)
summary(lm_disparos_bloqueados)##
## Call:
## lm(formula = total_blocked_shots ~ ., data = train)
##
## Residuals:
## Min 1Q Median 3Q Max
## -1.926e-12 -5.730e-15 -1.550e-15 3.330e-15 4.481e-13
##
## Coefficients: (16 not defined because of singularities)
## Estimate Std. Error t value Pr(>|t|)
## (Intercept) 5.499e-10 2.534e-10 2.170e+00 0.03011 *
## ...1 7.215e-16 3.310e-16 2.179e+00 0.02941 *
## Home_TeamALMERÍA 5.015e-16 1.160e-14 4.300e-02 0.96553
## Home_TeamATHLETIC 2.654e-15 6.708e-15 3.960e-01 0.69242
## Home_TeamATLETICO MADRID 3.393e-15 6.788e-15 5.000e-01 0.61728
## Home_TeamBARCELONA 6.123e-15 7.888e-15 7.760e-01 0.43764
## Home_TeamCELTA 4.945e-15 6.910e-15 7.160e-01 0.47433
## Home_TeamCÓRDOBA 2.290e-15 1.161e-14 1.970e-01 0.84369
## Home_TeamDEPORTIVO 4.009e-15 7.369e-15 5.440e-01 0.58653
## Home_TeamEIBAR 7.048e-15 6.839e-15 1.030e+00 0.30290
## Home_TeamELCHE 5.040e-15 1.164e-14 4.330e-01 0.66503
## Home_TeamESPANYOL 4.324e-15 6.641e-15 6.510e-01 0.51498
## Home_TeamGETAFE 5.901e-15 6.991e-15 8.440e-01 0.39876
## Home_TeamGIJÓN 6.560e-15 9.024e-15 7.270e-01 0.46730
## Home_TeamGIRONA 3.139e-15 8.873e-15 3.540e-01 0.72357
## Home_TeamGRANADA 4.713e-15 7.284e-15 6.470e-01 0.51770
## Home_TeamHUESCA 3.025e-15 1.141e-14 2.650e-01 0.79088
## Home_TeamLAS PALMAS 2.301e-16 8.312e-15 2.800e-02 0.97792
## Home_TeamLEGANÉS 1.148e-14 7.218e-15 1.590e+00 0.11201
## Home_TeamLEVANTE 7.010e-15 6.928e-15 1.012e+00 0.31173
## Home_TeamMÁLAGA -1.792e-14 7.354e-15 -2.436e+00 0.01492 *
## Home_TeamMALLORCA 4.449e-15 1.145e-14 3.890e-01 0.69763
## Home_TeamOSASUNA 4.948e-15 8.923e-15 5.550e-01 0.57929
## Home_TeamRAYO VALLECANO 7.925e-15 8.088e-15 9.800e-01 0.32728
## Home_TeamREAL BETIS 7.033e-15 7.163e-15 9.820e-01 0.32628
## Home_TeamREAL MADRID 9.773e-15 7.498e-15 1.303e+00 0.19256
## Home_TeamREAL SOCIEDAD 4.661e-15 6.839e-15 6.820e-01 0.49561
## Home_TeamSEVILLA FC 3.988e-15 6.944e-15 5.740e-01 0.56583
## Home_TeamVALENCIA 2.810e-15 6.814e-15 4.120e-01 0.68012
## Home_TeamVALLADOLID -1.200e-15 8.930e-15 -1.340e-01 0.89313
## Home_TeamVILLARREAL 5.904e-15 6.821e-15 8.660e-01 0.38684
## Away_TeamALMERÍA 1.064e-15 1.160e-14 9.200e-02 0.92693
## Away_TeamATHLETIC -1.929e-14 6.714e-15 -2.873e+00 0.00411 **
## Away_TeamATLETICO MADRID -1.581e-15 6.792e-15 -2.330e-01 0.81600
## Away_TeamBARCELONA 2.014e-15 7.921e-15 2.540e-01 0.79926
## Away_TeamCELTA -1.616e-15 6.823e-15 -2.370e-01 0.81281
## Away_TeamCÓRDOBA 4.536e-15 1.160e-14 3.910e-01 0.69588
## Away_TeamDEPORTIVO -1.852e-15 7.392e-15 -2.510e-01 0.80218
## Away_TeamEIBAR -7.241e-15 6.779e-15 -1.068e+00 0.28553
## Away_TeamELCHE 4.637e-16 1.160e-14 4.000e-02 0.96811
## Away_TeamESPANYOL -2.852e-15 6.635e-15 -4.300e-01 0.66732
## Away_TeamGETAFE -5.203e-15 6.977e-15 -7.460e-01 0.45591
## Away_TeamGIJÓN -1.265e-15 8.944e-15 -1.410e-01 0.88757
## Away_TeamGIRONA -2.007e-15 8.861e-15 -2.260e-01 0.82084
## Away_TeamGRANADA 1.555e-17 7.282e-15 2.000e-03 0.99830
## Away_TeamHUESCA -5.168e-15 1.135e-14 -4.550e-01 0.64884
## Away_TeamLAS PALMAS -3.735e-16 8.179e-15 -4.600e-02 0.96358
## Away_TeamLEGANÉS -4.141e-15 7.216e-15 -5.740e-01 0.56612
## Away_TeamLEVANTE 2.750e-16 6.883e-15 4.000e-02 0.96813
## Away_TeamMÁLAGA -3.472e-15 7.363e-15 -4.720e-01 0.63732
## Away_TeamMALLORCA -4.206e-15 1.144e-14 -3.680e-01 0.71303
## Away_TeamOSASUNA -4.316e-15 8.845e-15 -4.880e-01 0.62562
## Away_TeamRAYO VALLECANO -7.268e-16 8.097e-15 -9.000e-02 0.92849
## Away_TeamREAL BETIS 3.179e-15 7.153e-15 4.440e-01 0.65674
## Away_TeamREAL MADRID -1.064e-15 7.385e-15 -1.440e-01 0.88544
## Away_TeamREAL SOCIEDAD -3.482e-15 6.815e-15 -5.110e-01 0.60947
## Away_TeamSEVILLA FC 1.255e-15 6.818e-15 1.840e-01 0.85396
## Away_TeamVALENCIA 1.025e-15 6.776e-15 1.510e-01 0.87973
## Away_TeamVALLADOLID 2.010e-15 8.870e-15 2.270e-01 0.82078
## Away_TeamVILLARREAL 8.887e-16 6.770e-15 1.310e-01 0.89557
## `Home_Team_Possession_%` -2.463e-16 3.439e-16 -7.160e-01 0.47390
## `Away_Team_Possession_%` NA NA NA NA
## Home_Team_Off_Target_Shots 7.212e-15 5.199e-15 1.387e+00 0.16556
## Home_Team_On_Target_Shots 7.502e-15 5.200e-15 1.443e+00 0.14927
## Home_Team_Total_Shots -7.080e-15 5.178e-15 -1.367e+00 0.17163
## Home_Team_Blocked_Shots 1.000e+00 5.185e-15 1.929e+14 < 2e-16 ***
## Home_Team_Corners -2.459e-16 4.275e-16 -5.750e-01 0.56522
## Home_Team_Throw_Ins 3.361e-16 1.869e-16 1.799e+00 0.07221 .
## `Home_Team_Pass_Success_%` 4.790e-16 3.663e-16 1.308e+00 0.19114
## Home_Team_Aerials_Won 1.835e-18 1.946e-16 9.000e-03 0.99248
## Home_Team_Clearances 5.415e-17 1.657e-16 3.270e-01 0.74392
## Home_Team_Fouls 1.160e-16 2.723e-16 4.260e-01 0.67029
## Home_Team_Yellow_Cards -1.610e-16 6.989e-16 -2.300e-01 0.81787
## Home_Team_Second_Yellow_Cards -5.309e-17 3.988e-15 -1.300e-02 0.98938
## Home_Team_Red_Cards -3.914e-14 4.325e-15 -9.048e+00 < 2e-16 ***
## Away_Team_Off_Target_Shots -2.100e-15 4.465e-15 -4.700e-01 0.63823
## Away_Team_On_Target_Shots -2.781e-15 4.484e-15 -6.200e-01 0.53512
## Away_Team_Total_Shots 2.332e-15 4.450e-15 5.240e-01 0.60025
## Away_Team_Blocked_Shots 1.000e+00 4.486e-15 2.229e+14 < 2e-16 ***
## Away_Team_Corners 1.212e-16 4.679e-16 2.590e-01 0.79564
## Away_Team_Throw_Ins -2.279e-17 1.998e-16 -1.140e-01 0.90918
## `Away_Team_Pass_Success_%` -3.832e-16 3.412e-16 -1.123e+00 0.26157
## Away_Team_Aerials_Won -9.635e-18 1.922e-16 -5.000e-02 0.96003
## Away_Team_Clearances 1.675e-16 1.525e-16 1.098e+00 0.27242
## Away_Team_Fouls 4.707e-16 2.693e-16 1.748e+00 0.08058 .
## Away_Team_Yellow_Cards -4.989e-16 7.106e-16 -7.020e-01 0.48271
## Away_Team_Second_Yellow_Cards 1.377e-15 3.441e-15 4.000e-01 0.68902
## Away_Team_Red_Cards 3.133e-15 4.237e-15 7.390e-01 0.45971
## Home_Team_Goals_Scored 1.216e-15 1.223e-15 9.940e-01 0.32044
## Away_Team_Goals_Scored 1.202e-15 1.382e-15 8.700e-01 0.38464
## year -2.731e-13 1.258e-13 -2.170e+00 0.03009 *
## scorex 5.268e-15 3.072e-15 1.715e+00 0.08650 .
## score2 6.006e-15 4.360e-15 1.378e+00 0.16850
## goals NA NA NA NA
## home_points NA NA NA NA
## away_points NA NA NA NA
## jornada -7.076e-15 3.311e-15 -2.137e+00 0.03272 *
## total_off_target_shots NA NA NA NA
## total_on_target_shots NA NA NA NA
## total_shots NA NA NA NA
## total_corners NA NA NA NA
## total_throw_ins NA NA NA NA
## total_pass_success NA NA NA NA
## total_aerials_won NA NA NA NA
## total_clearances NA NA NA NA
## total_fouls NA NA NA NA
## total_yellow_cards NA NA NA NA
## total_second_yellow_cards NA NA NA NA
## total_red_cards NA NA NA NA
## ---
## Signif. codes: 0 '***' 0.001 '**' 0.01 '*' 0.05 '.' 0.1 ' ' 1
##
## Residual standard error: 4.389e-14 on 2187 degrees of freedom
## Multiple R-squared: 1, Adjusted R-squared: 1
## F-statistic: 8.752e+28 on 92 and 2187 DF, p-value: < 2.2e-16lm_corners <- lm(total_corners~., data = train)
summary(lm_corners)##
## Call:
## lm(formula = total_corners ~ ., data = train)
##
## Residuals:
## Min 1Q Median 3Q Max
## -3.206e-12 -9.000e-15 -2.200e-15 5.200e-15 2.392e-13
##
## Coefficients: (16 not defined because of singularities)
## Estimate Std. Error t value Pr(>|t|)
## (Intercept) 9.505e-10 4.120e-10 2.307e+00 0.02115 *
## ...1 1.248e-15 5.383e-16 2.319e+00 0.02048 *
## Home_TeamALMERÍA 1.194e-15 1.887e-14 6.300e-02 0.94957
## Home_TeamATHLETIC 1.213e-15 1.091e-14 1.110e-01 0.91149
## Home_TeamATLETICO MADRID 2.922e-15 1.104e-14 2.650e-01 0.79120
## Home_TeamBARCELONA 9.535e-15 1.282e-14 7.430e-01 0.45728
## Home_TeamCELTA 4.547e-15 1.123e-14 4.050e-01 0.68574
## Home_TeamCÓRDOBA -2.775e-16 1.888e-14 -1.500e-02 0.98828
## Home_TeamDEPORTIVO 6.664e-16 1.198e-14 5.600e-02 0.95565
## Home_TeamEIBAR 3.006e-15 1.112e-14 2.700e-01 0.78697
## Home_TeamELCHE 2.951e-15 1.892e-14 1.560e-01 0.87609
## Home_TeamESPANYOL 1.359e-15 1.080e-14 1.260e-01 0.89987
## Home_TeamGETAFE 9.281e-15 1.137e-14 8.160e-01 0.41431
## Home_TeamGIJÓN 5.420e-15 1.467e-14 3.690e-01 0.71187
## Home_TeamGIRONA -2.779e-15 1.443e-14 -1.930e-01 0.84727
## Home_TeamGRANADA 3.610e-15 1.184e-14 3.050e-01 0.76053
## Home_TeamHUESCA -5.105e-15 1.855e-14 -2.750e-01 0.78314
## Home_TeamLAS PALMAS 6.283e-16 1.352e-14 4.600e-02 0.96293
## Home_TeamLEGANÉS 2.634e-15 1.174e-14 2.240e-01 0.82242
## Home_TeamLEVANTE 6.078e-15 1.126e-14 5.400e-01 0.58954
## Home_TeamMÁLAGA -3.625e-14 1.196e-14 -3.032e+00 0.00246 **
## Home_TeamMALLORCA 5.773e-15 1.861e-14 3.100e-01 0.75649
## Home_TeamOSASUNA 2.648e-15 1.451e-14 1.820e-01 0.85521
## Home_TeamRAYO VALLECANO 5.360e-15 1.315e-14 4.080e-01 0.68365
## Home_TeamREAL BETIS 3.260e-15 1.165e-14 2.800e-01 0.77955
## Home_TeamREAL MADRID 4.905e-15 1.219e-14 4.020e-01 0.68743
## Home_TeamREAL SOCIEDAD 1.815e-15 1.112e-14 1.630e-01 0.87036
## Home_TeamSEVILLA FC 3.926e-15 1.129e-14 3.480e-01 0.72803
## Home_TeamVALENCIA 9.348e-16 1.108e-14 8.400e-02 0.93276
## Home_TeamVALLADOLID -4.173e-15 1.452e-14 -2.870e-01 0.77384
## Home_TeamVILLARREAL 4.499e-15 1.109e-14 4.060e-01 0.68500
## Away_TeamALMERÍA 1.049e-14 1.885e-14 5.560e-01 0.57813
## Away_TeamATHLETIC -2.360e-14 1.092e-14 -2.162e+00 0.03074 *
## Away_TeamATLETICO MADRID 1.437e-15 1.104e-14 1.300e-01 0.89649
## Away_TeamBARCELONA 9.250e-15 1.288e-14 7.180e-01 0.47269
## Away_TeamCELTA 1.482e-14 1.109e-14 1.336e+00 0.18158
## Away_TeamCÓRDOBA 3.929e-15 1.886e-14 2.080e-01 0.83506
## Away_TeamDEPORTIVO 8.113e-15 1.202e-14 6.750e-01 0.49973
## Away_TeamEIBAR 3.268e-15 1.102e-14 2.970e-01 0.76687
## Away_TeamELCHE 1.217e-14 1.886e-14 6.450e-01 0.51880
## Away_TeamESPANYOL 2.738e-15 1.079e-14 2.540e-01 0.79967
## Away_TeamGETAFE 2.524e-15 1.134e-14 2.230e-01 0.82393
## Away_TeamGIJÓN 8.525e-16 1.454e-14 5.900e-02 0.95326
## Away_TeamGIRONA 4.338e-15 1.441e-14 3.010e-01 0.76338
## Away_TeamGRANADA 2.116e-15 1.184e-14 1.790e-01 0.85820
## Away_TeamHUESCA -7.336e-15 1.845e-14 -3.980e-01 0.69096
## Away_TeamLAS PALMAS 7.845e-15 1.330e-14 5.900e-01 0.55530
## Away_TeamLEGANÉS -1.421e-15 1.173e-14 -1.210e-01 0.90359
## Away_TeamLEVANTE 2.940e-15 1.119e-14 2.630e-01 0.79276
## Away_TeamMÁLAGA 3.987e-15 1.197e-14 3.330e-01 0.73909
## Away_TeamMALLORCA -1.262e-15 1.859e-14 -6.800e-02 0.94587
## Away_TeamOSASUNA -4.229e-16 1.438e-14 -2.900e-02 0.97654
## Away_TeamRAYO VALLECANO 9.250e-15 1.317e-14 7.030e-01 0.48236
## Away_TeamREAL BETIS 1.141e-14 1.163e-14 9.810e-01 0.32673
## Away_TeamREAL MADRID 2.422e-16 1.201e-14 2.000e-02 0.98391
## Away_TeamREAL SOCIEDAD 2.158e-15 1.108e-14 1.950e-01 0.84559
## Away_TeamSEVILLA FC 4.373e-15 1.109e-14 3.940e-01 0.69329
## Away_TeamVALENCIA 3.403e-15 1.102e-14 3.090e-01 0.75740
## Away_TeamVALLADOLID 4.521e-15 1.442e-14 3.140e-01 0.75391
## Away_TeamVILLARREAL 2.991e-15 1.101e-14 2.720e-01 0.78586
## `Home_Team_Possession_%` -6.413e-16 5.592e-16 -1.147e+00 0.25159
## `Away_Team_Possession_%` NA NA NA NA
## Home_Team_Off_Target_Shots -1.440e-15 8.454e-15 -1.700e-01 0.86474
## Home_Team_On_Target_Shots -1.418e-15 8.455e-15 -1.680e-01 0.86683
## Home_Team_Total_Shots 2.014e-15 8.419e-15 2.390e-01 0.81092
## Home_Team_Blocked_Shots -2.676e-15 8.430e-15 -3.170e-01 0.75092
## Home_Team_Corners 1.000e+00 6.952e-16 1.439e+15 < 2e-16 ***
## Home_Team_Throw_Ins 4.072e-16 3.039e-16 1.340e+00 0.18040
## `Home_Team_Pass_Success_%` 1.103e-15 5.956e-16 1.853e+00 0.06405 .
## Home_Team_Aerials_Won 5.643e-17 3.163e-16 1.780e-01 0.85845
## Home_Team_Clearances 6.460e-16 2.695e-16 2.397e+00 0.01659 *
## Home_Team_Fouls 3.775e-16 4.428e-16 8.530e-01 0.39402
## Home_Team_Yellow_Cards -4.951e-16 1.136e-15 -4.360e-01 0.66312
## Home_Team_Second_Yellow_Cards -9.614e-17 6.484e-15 -1.500e-02 0.98817
## Home_Team_Red_Cards -6.173e-14 7.032e-15 -8.777e+00 < 2e-16 ***
## Away_Team_Off_Target_Shots 1.508e-15 7.260e-15 2.080e-01 0.83547
## Away_Team_On_Target_Shots 7.650e-16 7.291e-15 1.050e-01 0.91644
## Away_Team_Total_Shots -8.852e-16 7.236e-15 -1.220e-01 0.90264
## Away_Team_Blocked_Shots 1.946e-15 7.293e-15 2.670e-01 0.78963
## Away_Team_Corners 1.000e+00 7.607e-16 1.315e+15 < 2e-16 ***
## Away_Team_Throw_Ins 2.144e-16 3.248e-16 6.600e-01 0.50925
## `Away_Team_Pass_Success_%` -6.097e-16 5.548e-16 -1.099e+00 0.27188
## Away_Team_Aerials_Won -8.847e-17 3.125e-16 -2.830e-01 0.77715
## Away_Team_Clearances 1.831e-16 2.480e-16 7.380e-01 0.46055
## Away_Team_Fouls 6.692e-16 4.378e-16 1.528e+00 0.12655
## Away_Team_Yellow_Cards -3.324e-16 1.155e-15 -2.880e-01 0.77359
## Away_Team_Second_Yellow_Cards 5.051e-16 5.595e-15 9.000e-02 0.92807
## Away_Team_Red_Cards 6.042e-15 6.889e-15 8.770e-01 0.38057
## Home_Team_Goals_Scored 1.400e-15 1.989e-15 7.040e-01 0.48168
## Away_Team_Goals_Scored 1.466e-15 2.248e-15 6.520e-01 0.51418
## year -4.720e-13 2.046e-13 -2.307e+00 0.02113 *
## scorex 7.419e-15 4.994e-15 1.486e+00 0.13754
## score2 1.084e-14 7.089e-15 1.529e+00 0.12639
## goals NA NA NA NA
## home_points NA NA NA NA
## away_points NA NA NA NA
## jornada -1.220e-14 5.384e-15 -2.267e+00 0.02351 *
## total_off_target_shots NA NA NA NA
## total_on_target_shots NA NA NA NA
## total_shots NA NA NA NA
## total_blocked_shots NA NA NA NA
## total_throw_ins NA NA NA NA
## total_pass_success NA NA NA NA
## total_aerials_won NA NA NA NA
## total_clearances NA NA NA NA
## total_fouls NA NA NA NA
## total_yellow_cards NA NA NA NA
## total_second_yellow_cards NA NA NA NA
## total_red_cards NA NA NA NA
## ---
## Signif. codes: 0 '***' 0.001 '**' 0.01 '*' 0.05 '.' 0.1 ' ' 1
##
## Residual standard error: 7.136e-14 on 2187 degrees of freedom
## Multiple R-squared: 1, Adjusted R-squared: 1
## F-statistic: 5.553e+28 on 92 and 2187 DF, p-value: < 2.2e-16lm_centros <- lm(total_throw_ins~., data = train)
summary(lm_centros)##
## Call:
## lm(formula = total_throw_ins ~ ., data = train)
##
## Residuals:
## Min 1Q Median 3Q Max
## -4.561e-12 -1.320e-14 -2.500e-15 8.600e-15 6.560e-13
##
## Coefficients: (16 not defined because of singularities)
## Estimate Std. Error t value Pr(>|t|)
## (Intercept) 1.279e-09 5.956e-10 2.148e+00 0.031834 *
## ...1 1.683e-15 7.781e-16 2.163e+00 0.030613 *
## Home_TeamALMERÍA 8.982e-15 2.727e-14 3.290e-01 0.741949
## Home_TeamATHLETIC 9.438e-15 1.577e-14 5.990e-01 0.549515
## Home_TeamATLETICO MADRID 2.146e-15 1.595e-14 1.350e-01 0.893004
## Home_TeamBARCELONA 3.341e-14 1.854e-14 1.802e+00 0.071659 .
## Home_TeamCELTA 1.445e-14 1.624e-14 8.900e-01 0.373674
## Home_TeamCÓRDOBA 2.248e-14 2.729e-14 8.240e-01 0.410206
## Home_TeamDEPORTIVO 2.687e-15 1.732e-14 1.550e-01 0.876724
## Home_TeamEIBAR 5.974e-15 1.608e-14 3.720e-01 0.710198
## Home_TeamELCHE 1.171e-14 2.736e-14 4.280e-01 0.668734
## Home_TeamESPANYOL -1.293e-15 1.561e-14 -8.300e-02 0.933969
## Home_TeamGETAFE -5.727e-15 1.643e-14 -3.490e-01 0.727463
## Home_TeamGIJÓN 1.327e-14 2.121e-14 6.260e-01 0.531656
## Home_TeamGIRONA -2.835e-15 2.086e-14 -1.360e-01 0.891882
## Home_TeamGRANADA -1.696e-14 1.712e-14 -9.910e-01 0.321934
## Home_TeamHUESCA -2.742e-15 2.681e-14 -1.020e-01 0.918554
## Home_TeamLAS PALMAS 3.309e-15 1.954e-14 1.690e-01 0.865528
## Home_TeamLEGANÉS 1.003e-14 1.696e-14 5.910e-01 0.554605
## Home_TeamLEVANTE 9.695e-15 1.628e-14 5.950e-01 0.551632
## Home_TeamMÁLAGA -5.999e-14 1.728e-14 -3.471e+00 0.000529 ***
## Home_TeamMALLORCA -9.780e-15 2.691e-14 -3.630e-01 0.716291
## Home_TeamOSASUNA -2.108e-14 2.097e-14 -1.005e+00 0.315058
## Home_TeamRAYO VALLECANO 1.802e-14 1.901e-14 9.480e-01 0.343302
## Home_TeamREAL BETIS 3.281e-15 1.683e-14 1.950e-01 0.845468
## Home_TeamREAL MADRID 1.358e-14 1.762e-14 7.710e-01 0.440945
## Home_TeamREAL SOCIEDAD 2.423e-15 1.608e-14 1.510e-01 0.880186
## Home_TeamSEVILLA FC -2.065e-15 1.632e-14 -1.270e-01 0.899333
## Home_TeamVALENCIA 4.557e-15 1.602e-14 2.850e-01 0.776040
## Home_TeamVALLADOLID -1.345e-15 2.099e-14 -6.400e-02 0.948904
## Home_TeamVILLARREAL 4.258e-16 1.603e-14 2.700e-02 0.978814
## Away_TeamALMERÍA 1.862e-14 2.726e-14 6.830e-01 0.494639
## Away_TeamATHLETIC -3.856e-14 1.578e-14 -2.443e+00 0.014631 *
## Away_TeamATLETICO MADRID 5.965e-15 1.596e-14 3.740e-01 0.708710
## Away_TeamBARCELONA 1.505e-14 1.862e-14 8.080e-01 0.418978
## Away_TeamCELTA 3.889e-15 1.604e-14 2.420e-01 0.808426
## Away_TeamCÓRDOBA 5.232e-16 2.727e-14 1.900e-02 0.984694
## Away_TeamDEPORTIVO -7.569e-16 1.737e-14 -4.400e-02 0.965254
## Away_TeamEIBAR 1.049e-14 1.593e-14 6.580e-01 0.510297
## Away_TeamELCHE 5.249e-15 2.726e-14 1.930e-01 0.847349
## Away_TeamESPANYOL -6.853e-15 1.560e-14 -4.390e-01 0.660373
## Away_TeamGETAFE -1.629e-15 1.640e-14 -9.900e-02 0.920886
## Away_TeamGIJÓN -1.627e-14 2.102e-14 -7.740e-01 0.438976
## Away_TeamGIRONA 2.354e-15 2.083e-14 1.130e-01 0.910012
## Away_TeamGRANADA 1.501e-14 1.711e-14 8.770e-01 0.380618
## Away_TeamHUESCA -1.746e-14 2.667e-14 -6.550e-01 0.512827
## Away_TeamLAS PALMAS 5.988e-15 1.922e-14 3.120e-01 0.755447
## Away_TeamLEGANÉS -4.083e-15 1.696e-14 -2.410e-01 0.809794
## Away_TeamLEVANTE -3.903e-15 1.618e-14 -2.410e-01 0.809368
## Away_TeamMÁLAGA -8.357e-15 1.730e-14 -4.830e-01 0.629207
## Away_TeamMALLORCA -1.423e-14 2.688e-14 -5.290e-01 0.596595
## Away_TeamOSASUNA -7.924e-15 2.079e-14 -3.810e-01 0.703136
## Away_TeamRAYO VALLECANO 1.511e-15 1.903e-14 7.900e-02 0.936720
## Away_TeamREAL BETIS 3.906e-15 1.681e-14 2.320e-01 0.816304
## Away_TeamREAL MADRID -1.719e-15 1.736e-14 -9.900e-02 0.921138
## Away_TeamREAL SOCIEDAD -1.146e-14 1.602e-14 -7.150e-01 0.474391
## Away_TeamSEVILLA FC -8.318e-15 1.602e-14 -5.190e-01 0.603735
## Away_TeamVALENCIA -1.018e-15 1.592e-14 -6.400e-02 0.949042
## Away_TeamVALLADOLID -5.975e-15 2.085e-14 -2.870e-01 0.774433
## Away_TeamVILLARREAL -9.953e-15 1.591e-14 -6.260e-01 0.531667
## `Home_Team_Possession_%` -1.568e-15 8.083e-16 -1.940e+00 0.052567 .
## `Away_Team_Possession_%` NA NA NA NA
## Home_Team_Off_Target_Shots 5.660e-16 1.222e-14 4.600e-02 0.963061
## Home_Team_On_Target_Shots 2.278e-15 1.222e-14 1.860e-01 0.852185
## Home_Team_Total_Shots 7.931e-17 1.217e-14 7.000e-03 0.994801
## Home_Team_Blocked_Shots -1.246e-15 1.219e-14 -1.020e-01 0.918603
## Home_Team_Corners -4.752e-16 1.005e-15 -4.730e-01 0.636339
## Home_Team_Throw_Ins 1.000e+00 4.392e-16 2.277e+15 < 2e-16 ***
## `Home_Team_Pass_Success_%` 2.516e-15 8.609e-16 2.923e+00 0.003506 **
## Home_Team_Aerials_Won 4.588e-17 4.573e-16 1.000e-01 0.920087
## Home_Team_Clearances -1.845e-16 3.895e-16 -4.740e-01 0.635808
## Home_Team_Fouls 1.052e-15 6.400e-16 1.643e+00 0.100524
## Home_Team_Yellow_Cards -2.302e-16 1.643e-15 -1.400e-01 0.888567
## Home_Team_Second_Yellow_Cards 1.835e-15 9.372e-15 1.960e-01 0.844780
## Home_Team_Red_Cards -8.440e-14 1.017e-14 -8.303e+00 < 2e-16 ***
## Away_Team_Off_Target_Shots 2.376e-15 1.049e-14 2.260e-01 0.820881
## Away_Team_On_Target_Shots -4.387e-16 1.054e-14 -4.200e-02 0.966799
## Away_Team_Total_Shots -6.522e-16 1.046e-14 -6.200e-02 0.950288
## Away_Team_Blocked_Shots 1.204e-15 1.054e-14 1.140e-01 0.909067
## Away_Team_Corners 1.681e-15 1.100e-15 1.529e+00 0.126525
## Away_Team_Throw_Ins 1.000e+00 4.696e-16 2.130e+15 < 2e-16 ***
## `Away_Team_Pass_Success_%` -6.680e-16 8.020e-16 -8.330e-01 0.405003
## Away_Team_Aerials_Won -1.403e-16 4.518e-16 -3.110e-01 0.756199
## Away_Team_Clearances 3.342e-16 3.585e-16 9.320e-01 0.351382
## Away_Team_Fouls 9.319e-16 6.329e-16 1.472e+00 0.141063
## Away_Team_Yellow_Cards -6.374e-16 1.670e-15 -3.820e-01 0.702764
## Away_Team_Second_Yellow_Cards 3.181e-15 8.087e-15 3.930e-01 0.694108
## Away_Team_Red_Cards 1.157e-14 9.958e-15 1.161e+00 0.245595
## Home_Team_Goals_Scored 2.836e-15 2.875e-15 9.860e-01 0.324029
## Away_Team_Goals_Scored 1.630e-15 3.249e-15 5.020e-01 0.615961
## year -6.354e-13 2.957e-13 -2.148e+00 0.031785 *
## scorex 1.171e-14 7.219e-15 1.622e+00 0.104898
## score2 1.861e-14 1.025e-14 1.816e+00 0.069551 .
## goals NA NA NA NA
## home_points NA NA NA NA
## away_points NA NA NA NA
## jornada -1.638e-14 7.783e-15 -2.104e+00 0.035454 *
## total_off_target_shots NA NA NA NA
## total_on_target_shots NA NA NA NA
## total_shots NA NA NA NA
## total_blocked_shots NA NA NA NA
## total_corners NA NA NA NA
## total_pass_success NA NA NA NA
## total_aerials_won NA NA NA NA
## total_clearances NA NA NA NA
## total_fouls NA NA NA NA
## total_yellow_cards NA NA NA NA
## total_second_yellow_cards NA NA NA NA
## total_red_cards NA NA NA NA
## ---
## Signif. codes: 0 '***' 0.001 '**' 0.01 '*' 0.05 '.' 0.1 ' ' 1
##
## Residual standard error: 1.032e-13 on 2187 degrees of freedom
## Multiple R-squared: 1, Adjusted R-squared: 1
## F-statistic: 2.616e+29 on 92 and 2187 DF, p-value: < 2.2e-16lm_d_aereos <- lm(total_aerials_won~., data = train)
summary(lm_d_aereos)##
## Call:
## lm(formula = total_aerials_won ~ ., data = train)
##
## Residuals:
## Min 1Q Median 3Q Max
## -1.409e-12 -6.110e-15 -6.600e-16 5.370e-15 6.267e-13
##
## Coefficients: (16 not defined because of singularities)
## Estimate Std. Error t value Pr(>|t|)
## (Intercept) 1.964e-10 2.266e-10 8.670e-01 0.386164
## ...1 2.661e-16 2.961e-16 8.990e-01 0.368910
## Home_TeamALMERÍA 4.345e-15 1.038e-14 4.190e-01 0.675488
## Home_TeamATHLETIC 2.631e-14 6.000e-15 4.386e+00 1.21e-05 ***
## Home_TeamATLETICO MADRID 1.676e-14 6.071e-15 2.761e+00 0.005812 **
## Home_TeamBARCELONA -2.925e-14 7.055e-15 -4.146e+00 3.51e-05 ***
## Home_TeamCELTA 1.686e-14 6.180e-15 2.727e+00 0.006435 **
## Home_TeamCÓRDOBA 2.973e-14 1.039e-14 2.862e+00 0.004251 **
## Home_TeamDEPORTIVO 1.695e-14 6.591e-15 2.571e+00 0.010196 *
## Home_TeamEIBAR -9.792e-15 6.117e-15 -1.601e+00 0.109595
## Home_TeamELCHE 1.849e-14 1.041e-14 1.776e+00 0.075824 .
## Home_TeamESPANYOL 2.433e-14 5.939e-15 4.096e+00 4.36e-05 ***
## Home_TeamGETAFE 2.789e-15 6.253e-15 4.460e-01 0.655656
## Home_TeamGIJÓN 2.944e-15 8.071e-15 3.650e-01 0.715323
## Home_TeamGIRONA 4.519e-15 7.936e-15 5.690e-01 0.569145
## Home_TeamGRANADA 8.437e-15 6.515e-15 1.295e+00 0.195435
## Home_TeamHUESCA 1.931e-14 1.020e-14 1.893e+00 0.058449 .
## Home_TeamLAS PALMAS 2.714e-14 7.434e-15 3.650e+00 0.000268 ***
## Home_TeamLEGANÉS 1.616e-14 6.456e-15 2.503e+00 0.012378 *
## Home_TeamLEVANTE 7.478e-15 6.196e-15 1.207e+00 0.227626
## Home_TeamMÁLAGA -3.570e-15 6.577e-15 -5.430e-01 0.587304
## Home_TeamMALLORCA 2.996e-14 1.024e-14 2.926e+00 0.003470 **
## Home_TeamOSASUNA -2.142e-14 7.981e-15 -2.684e+00 0.007322 **
## Home_TeamRAYO VALLECANO 1.318e-14 7.234e-15 1.822e+00 0.068565 .
## Home_TeamREAL BETIS 7.066e-15 6.406e-15 1.103e+00 0.270145
## Home_TeamREAL MADRID 2.102e-14 6.706e-15 3.135e+00 0.001744 **
## Home_TeamREAL SOCIEDAD 1.722e-14 6.117e-15 2.814e+00 0.004933 **
## Home_TeamSEVILLA FC 1.184e-14 6.210e-15 1.906e+00 0.056764 .
## Home_TeamVALENCIA 1.186e-14 6.094e-15 1.947e+00 0.051715 .
## Home_TeamVALLADOLID 1.209e-14 7.987e-15 1.514e+00 0.130292
## Home_TeamVILLARREAL 2.666e-14 6.101e-15 4.370e+00 1.30e-05 ***
## Away_TeamALMERÍA 8.576e-15 1.037e-14 8.270e-01 0.408383
## Away_TeamATHLETIC 2.122e-15 6.005e-15 3.530e-01 0.723882
## Away_TeamATLETICO MADRID 2.196e-14 6.075e-15 3.615e+00 0.000308 ***
## Away_TeamBARCELONA -6.251e-14 7.084e-15 -8.824e+00 < 2e-16 ***
## Away_TeamCELTA 9.182e-15 6.102e-15 1.505e+00 0.132539
## Away_TeamCÓRDOBA 1.043e-14 1.038e-14 1.005e+00 0.315128
## Away_TeamDEPORTIVO 1.003e-14 6.611e-15 1.517e+00 0.129299
## Away_TeamEIBAR 2.040e-14 6.063e-15 3.364e+00 0.000781 ***
## Away_TeamELCHE 1.337e-14 1.037e-14 1.289e+00 0.197686
## Away_TeamESPANYOL 2.366e-16 5.934e-15 4.000e-02 0.968205
## Away_TeamGETAFE -1.128e-14 6.240e-15 -1.808e+00 0.070712 .
## Away_TeamGIJÓN -3.893e-15 8.000e-15 -4.870e-01 0.626537
## Away_TeamGIRONA 1.645e-14 7.926e-15 2.075e+00 0.038097 *
## Away_TeamGRANADA 3.232e-15 6.513e-15 4.960e-01 0.619789
## Away_TeamHUESCA -8.399e-15 1.015e-14 -8.280e-01 0.408002
## Away_TeamLAS PALMAS 2.448e-14 7.315e-15 3.346e+00 0.000834 ***
## Away_TeamLEGANÉS -5.181e-17 6.454e-15 -8.000e-03 0.993596
## Away_TeamLEVANTE 3.237e-15 6.156e-15 5.260e-01 0.599098
## Away_TeamMÁLAGA 5.105e-15 6.585e-15 7.750e-01 0.438267
## Away_TeamMALLORCA 1.801e-14 1.023e-14 1.761e+00 0.078394 .
## Away_TeamOSASUNA -1.724e-15 7.911e-15 -2.180e-01 0.827489
## Away_TeamRAYO VALLECANO -1.662e-14 7.242e-15 -2.295e+00 0.021811 *
## Away_TeamREAL BETIS 4.912e-15 6.397e-15 7.680e-01 0.442688
## Away_TeamREAL MADRID 1.544e-14 6.605e-15 2.338e+00 0.019483 *
## Away_TeamREAL SOCIEDAD 3.695e-15 6.096e-15 6.060e-01 0.544483
## Away_TeamSEVILLA FC 8.350e-15 6.098e-15 1.369e+00 0.171048
## Away_TeamVALENCIA 5.095e-15 6.060e-15 8.410e-01 0.400528
## Away_TeamVALLADOLID 7.520e-15 7.933e-15 9.480e-01 0.343224
## Away_TeamVILLARREAL 3.972e-15 6.055e-15 6.560e-01 0.511879
## `Home_Team_Possession_%` 4.632e-16 3.076e-16 1.506e+00 0.132261
## `Away_Team_Possession_%` NA NA NA NA
## Home_Team_Off_Target_Shots 1.935e-15 4.650e-15 4.160e-01 0.677327
## Home_Team_On_Target_Shots 3.656e-16 4.651e-15 7.900e-02 0.937355
## Home_Team_Total_Shots -1.289e-15 4.631e-15 -2.780e-01 0.780741
## Home_Team_Blocked_Shots 1.097e-15 4.637e-15 2.370e-01 0.813007
## Home_Team_Corners 1.692e-16 3.824e-16 4.420e-01 0.658200
## Home_Team_Throw_Ins -2.690e-16 1.671e-16 -1.610e+00 0.107647
## `Home_Team_Pass_Success_%` -1.888e-15 3.276e-16 -5.761e+00 9.52e-09 ***
## Home_Team_Aerials_Won 1.000e+00 1.740e-16 5.747e+15 < 2e-16 ***
## Home_Team_Clearances 2.143e-16 1.482e-16 1.446e+00 0.148368
## Home_Team_Fouls 3.788e-16 2.436e-16 1.555e+00 0.120037
## Home_Team_Yellow_Cards -3.871e-17 6.251e-16 -6.200e-02 0.950620
## Home_Team_Second_Yellow_Cards 3.306e-15 3.566e-15 9.270e-01 0.354000
## Home_Team_Red_Cards -2.979e-14 3.868e-15 -7.701e+00 2.04e-14 ***
## Away_Team_Off_Target_Shots -1.096e-15 3.994e-15 -2.740e-01 0.783827
## Away_Team_On_Target_Shots -1.942e-15 4.010e-15 -4.840e-01 0.628343
## Away_Team_Total_Shots 1.630e-15 3.980e-15 4.090e-01 0.682291
## Away_Team_Blocked_Shots -1.912e-15 4.012e-15 -4.760e-01 0.633784
## Away_Team_Corners -2.189e-16 4.185e-16 -5.230e-01 0.600876
## Away_Team_Throw_Ins -1.553e-16 1.787e-16 -8.690e-01 0.384972
## `Away_Team_Pass_Success_%` -1.052e-15 3.052e-16 -3.446e+00 0.000580 ***
## Away_Team_Aerials_Won 1.000e+00 1.719e-16 5.817e+15 < 2e-16 ***
## Away_Team_Clearances 7.167e-18 1.364e-16 5.300e-02 0.958110
## Away_Team_Fouls 3.612e-16 2.408e-16 1.500e+00 0.133843
## Away_Team_Yellow_Cards 3.082e-16 6.356e-16 4.850e-01 0.627847
## Away_Team_Second_Yellow_Cards -2.030e-15 3.077e-15 -6.600e-01 0.509526
## Away_Team_Red_Cards 1.201e-15 3.789e-15 3.170e-01 0.751246
## Home_Team_Goals_Scored 1.478e-15 1.094e-15 1.350e+00 0.177010
## Away_Team_Goals_Scored 3.674e-16 1.236e-15 2.970e-01 0.766345
## year -9.746e-14 1.125e-13 -8.660e-01 0.386574
## scorex 5.450e-15 2.747e-15 1.984e+00 0.047417 *
## score2 8.638e-15 3.899e-15 2.215e+00 0.026848 *
## goals NA NA NA NA
## home_points NA NA NA NA
## away_points NA NA NA NA
## jornada -2.441e-15 2.962e-15 -8.240e-01 0.409861
## total_off_target_shots NA NA NA NA
## total_on_target_shots NA NA NA NA
## total_shots NA NA NA NA
## total_blocked_shots NA NA NA NA
## total_corners NA NA NA NA
## total_throw_ins NA NA NA NA
## total_pass_success NA NA NA NA
## total_clearances NA NA NA NA
## total_fouls NA NA NA NA
## total_yellow_cards NA NA NA NA
## total_second_yellow_cards NA NA NA NA
## total_red_cards NA NA NA NA
## ---
## Signif. codes: 0 '***' 0.001 '**' 0.01 '*' 0.05 '.' 0.1 ' ' 1
##
## Residual standard error: 3.925e-14 on 2187 degrees of freedom
## Multiple R-squared: 1, Adjusted R-squared: 1
## F-statistic: 2.847e+30 on 92 and 2187 DF, p-value: < 2.2e-16lm_despejes <- lm(total_clearances~., data = train)
summary(lm_despejes)##
## Call:
## lm(formula = total_clearances ~ ., data = train)
##
## Residuals:
## Min 1Q Median 3Q Max
## -1.384e-12 -6.370e-15 -4.700e-16 6.720e-15 3.155e-13
##
## Coefficients: (16 not defined because of singularities)
## Estimate Std. Error t value Pr(>|t|)
## (Intercept) 2.451e-10 2.380e-10 1.030e+00 0.303274
## ...1 3.139e-16 3.109e-16 1.009e+00 0.312853
## Home_TeamALMERÍA 3.201e-14 1.090e-14 2.937e+00 0.003349 **
## Home_TeamATHLETIC 4.102e-14 6.300e-15 6.510e+00 9.29e-11 ***
## Home_TeamATLETICO MADRID 2.567e-14 6.376e-15 4.027e+00 5.85e-05 ***
## Home_TeamBARCELONA 1.654e-14 7.408e-15 2.233e+00 0.025672 *
## Home_TeamCELTA 2.956e-14 6.490e-15 4.556e+00 5.51e-06 ***
## Home_TeamCÓRDOBA 2.082e-14 1.091e-14 1.909e+00 0.056414 .
## Home_TeamDEPORTIVO 2.790e-14 6.921e-15 4.031e+00 5.73e-05 ***
## Home_TeamEIBAR 3.734e-14 6.424e-15 5.812e+00 7.07e-09 ***
## Home_TeamELCHE 1.135e-14 1.093e-14 1.038e+00 0.299429
## Home_TeamESPANYOL 1.398e-14 6.237e-15 2.242e+00 0.025047 *
## Home_TeamGETAFE 6.179e-15 6.566e-15 9.410e-01 0.346799
## Home_TeamGIJÓN 2.463e-14 8.475e-15 2.906e+00 0.003701 **
## Home_TeamGIRONA 2.812e-14 8.334e-15 3.374e+00 0.000754 ***
## Home_TeamGRANADA 1.265e-14 6.841e-15 1.849e+00 0.064597 .
## Home_TeamHUESCA 3.474e-14 1.071e-14 3.242e+00 0.001203 **
## Home_TeamLAS PALMAS 3.224e-14 7.807e-15 4.130e+00 3.76e-05 ***
## Home_TeamLEGANÉS 2.053e-14 6.779e-15 3.028e+00 0.002493 **
## Home_TeamLEVANTE 2.802e-14 6.507e-15 4.306e+00 1.74e-05 ***
## Home_TeamMÁLAGA 8.625e-15 6.907e-15 1.249e+00 0.211885
## Home_TeamMALLORCA 1.020e-14 1.075e-14 9.490e-01 0.342750
## Home_TeamOSASUNA 2.575e-14 8.381e-15 3.072e+00 0.002153 **
## Home_TeamRAYO VALLECANO 2.180e-14 7.597e-15 2.869e+00 0.004153 **
## Home_TeamREAL BETIS 2.531e-14 6.727e-15 3.763e+00 0.000173 ***
## Home_TeamREAL MADRID 3.311e-14 7.042e-15 4.703e+00 2.73e-06 ***
## Home_TeamREAL SOCIEDAD 3.010e-14 6.424e-15 4.685e+00 2.97e-06 ***
## Home_TeamSEVILLA FC 4.758e-14 6.522e-15 7.295e+00 4.15e-13 ***
## Home_TeamVALENCIA 1.910e-14 6.400e-15 2.985e+00 0.002870 **
## Home_TeamVALLADOLID 1.335e-14 8.387e-15 1.592e+00 0.111610
## Home_TeamVILLARREAL 1.935e-14 6.406e-15 3.020e+00 0.002557 **
## Away_TeamALMERÍA -2.942e-14 1.089e-14 -2.701e+00 0.006958 **
## Away_TeamATHLETIC -4.387e-14 6.306e-15 -6.956e+00 4.60e-12 ***
## Away_TeamATLETICO MADRID -4.127e-14 6.379e-15 -6.469e+00 1.21e-10 ***
## Away_TeamBARCELONA -3.339e-14 7.439e-15 -4.489e+00 7.53e-06 ***
## Away_TeamCELTA -2.867e-14 6.408e-15 -4.474e+00 8.08e-06 ***
## Away_TeamCÓRDOBA 4.079e-15 1.090e-14 3.740e-01 0.708180
## Away_TeamDEPORTIVO -2.138e-14 6.942e-15 -3.080e+00 0.002094 **
## Away_TeamEIBAR -3.296e-14 6.367e-15 -5.177e+00 2.47e-07 ***
## Away_TeamELCHE -2.126e-14 1.089e-14 -1.951e+00 0.051152 .
## Away_TeamESPANYOL -1.810e-14 6.232e-15 -2.905e+00 0.003709 **
## Away_TeamGETAFE -1.719e-14 6.553e-15 -2.623e+00 0.008787 **
## Away_TeamGIJÓN -7.920e-15 8.400e-15 -9.430e-01 0.345900
## Away_TeamGIRONA -1.502e-14 8.323e-15 -1.805e+00 0.071234 .
## Away_TeamGRANADA -1.483e-14 6.839e-15 -2.168e+00 0.030290 *
## Away_TeamHUESCA -3.403e-15 1.066e-14 -3.190e-01 0.749555
## Away_TeamLAS PALMAS -4.276e-14 7.682e-15 -5.567e+00 2.91e-08 ***
## Away_TeamLEGANÉS -2.122e-14 6.778e-15 -3.131e+00 0.001764 **
## Away_TeamLEVANTE -1.499e-14 6.464e-15 -2.319e+00 0.020486 *
## Away_TeamMÁLAGA -2.776e-14 6.915e-15 -4.015e+00 6.16e-05 ***
## Away_TeamMALLORCA -2.882e-14 1.074e-14 -2.683e+00 0.007354 **
## Away_TeamOSASUNA -6.623e-15 8.308e-15 -7.970e-01 0.425434
## Away_TeamRAYO VALLECANO -2.297e-14 7.605e-15 -3.021e+00 0.002550 **
## Away_TeamREAL BETIS -2.025e-14 6.718e-15 -3.014e+00 0.002608 **
## Away_TeamREAL MADRID -6.095e-14 6.936e-15 -8.787e+00 < 2e-16 ***
## Away_TeamREAL SOCIEDAD -2.286e-14 6.401e-15 -3.571e+00 0.000363 ***
## Away_TeamSEVILLA FC -2.705e-14 6.403e-15 -4.225e+00 2.49e-05 ***
## Away_TeamVALENCIA -8.078e-15 6.364e-15 -1.269e+00 0.204402
## Away_TeamVALLADOLID -3.326e-15 8.330e-15 -3.990e-01 0.689731
## Away_TeamVILLARREAL -9.608e-15 6.358e-15 -1.511e+00 0.130904
## `Home_Team_Possession_%` -9.239e-16 3.230e-16 -2.860e+00 0.004271 **
## `Away_Team_Possession_%` NA NA NA NA
## Home_Team_Off_Target_Shots 4.263e-16 4.883e-15 8.700e-02 0.930446
## Home_Team_On_Target_Shots 1.082e-15 4.884e-15 2.220e-01 0.824636
## Home_Team_Total_Shots -3.808e-17 4.863e-15 -8.000e-03 0.993752
## Home_Team_Blocked_Shots 8.539e-16 4.870e-15 1.750e-01 0.860819
## Home_Team_Corners -9.671e-16 4.016e-16 -2.408e+00 0.016108 *
## Home_Team_Throw_Ins 1.130e-15 1.755e-16 6.439e+00 1.48e-10 ***
## `Home_Team_Pass_Success_%` -3.685e-17 3.440e-16 -1.070e-01 0.914715
## Home_Team_Aerials_Won 5.874e-17 1.827e-16 3.210e-01 0.747889
## Home_Team_Clearances 1.000e+00 1.556e-16 6.425e+15 < 2e-16 ***
## Home_Team_Fouls 2.125e-16 2.558e-16 8.310e-01 0.406140
## Home_Team_Yellow_Cards 7.219e-16 6.564e-16 1.100e+00 0.271556
## Home_Team_Second_Yellow_Cards 1.355e-15 3.745e-15 3.620e-01 0.717628
## Home_Team_Red_Cards -2.667e-14 4.062e-15 -6.565e+00 6.48e-11 ***
## Away_Team_Off_Target_Shots 4.238e-15 4.194e-15 1.011e+00 0.312341
## Away_Team_On_Target_Shots 3.139e-15 4.211e-15 7.450e-01 0.456087
## Away_Team_Total_Shots -3.236e-15 4.180e-15 -7.740e-01 0.438864
## Away_Team_Blocked_Shots 3.412e-15 4.213e-15 8.100e-01 0.418137
## Away_Team_Corners -4.319e-16 4.394e-16 -9.830e-01 0.325806
## Away_Team_Throw_Ins 2.197e-17 1.876e-16 1.170e-01 0.906789
## `Away_Team_Pass_Success_%` 2.711e-16 3.205e-16 8.460e-01 0.397639
## Away_Team_Aerials_Won 1.230e-16 1.805e-16 6.820e-01 0.495582
## Away_Team_Clearances 1.000e+00 1.433e-16 6.980e+15 < 2e-16 ***
## Away_Team_Fouls 1.961e-16 2.529e-16 7.750e-01 0.438175
## Away_Team_Yellow_Cards 1.458e-16 6.674e-16 2.180e-01 0.827112
## Away_Team_Second_Yellow_Cards 3.318e-16 3.232e-15 1.030e-01 0.918225
## Away_Team_Red_Cards 8.245e-15 3.979e-15 2.072e+00 0.038387 *
## Home_Team_Goals_Scored -6.771e-17 1.149e-15 -5.900e-02 0.953017
## Away_Team_Goals_Scored 1.123e-15 1.298e-15 8.650e-01 0.387204
## year -1.217e-13 1.182e-13 -1.030e+00 0.303166
## scorex 2.584e-16 2.885e-15 9.000e-02 0.928632
## score2 2.855e-15 4.095e-15 6.970e-01 0.485762
## goals NA NA NA NA
## home_points NA NA NA NA
## away_points NA NA NA NA
## jornada -2.994e-15 3.110e-15 -9.630e-01 0.335786
## total_off_target_shots NA NA NA NA
## total_on_target_shots NA NA NA NA
## total_shots NA NA NA NA
## total_blocked_shots NA NA NA NA
## total_corners NA NA NA NA
## total_throw_ins NA NA NA NA
## total_pass_success NA NA NA NA
## total_aerials_won NA NA NA NA
## total_fouls NA NA NA NA
## total_yellow_cards NA NA NA NA
## total_second_yellow_cards NA NA NA NA
## total_red_cards NA NA NA NA
## ---
## Signif. codes: 0 '***' 0.001 '**' 0.01 '*' 0.05 '.' 0.1 ' ' 1
##
## Residual standard error: 4.122e-14 on 2187 degrees of freedom
## Multiple R-squared: 1, Adjusted R-squared: 1
## F-statistic: 1.858e+30 on 92 and 2187 DF, p-value: < 2.2e-16lm_faltas <- lm(total_fouls~., data = train)
summary(lm_faltas)##
## Call:
## lm(formula = total_fouls ~ ., data = train)
##
## Residuals:
## Min 1Q Median 3Q Max
## -6.540e-13 -1.200e-14 6.000e-15 2.250e-14 7.834e-12
##
## Coefficients: (16 not defined because of singularities)
## Estimate Std. Error t value Pr(>|t|)
## (Intercept) -2.030e-09 1.006e-09 -2.018e+00 0.04374 *
## ...1 -2.666e-15 1.315e-15 -2.028e+00 0.04268 *
## Home_TeamALMERÍA -3.147e-14 4.608e-14 -6.830e-01 0.49466
## Home_TeamATHLETIC -1.332e-14 2.664e-14 -5.000e-01 0.61719
## Home_TeamATLETICO MADRID -1.377e-14 2.695e-14 -5.110e-01 0.60952
## Home_TeamBARCELONA -3.961e-14 3.132e-14 -1.265e+00 0.20614
## Home_TeamCELTA -2.154e-14 2.744e-14 -7.850e-01 0.43250
## Home_TeamCÓRDOBA -1.465e-14 4.611e-14 -3.180e-01 0.75071
## Home_TeamDEPORTIVO -1.459e-14 2.926e-14 -4.990e-01 0.61803
## Home_TeamEIBAR -1.863e-14 2.716e-14 -6.860e-01 0.49276
## Home_TeamELCHE -1.212e-14 4.622e-14 -2.620e-01 0.79320
## Home_TeamESPANYOL -4.794e-15 2.637e-14 -1.820e-01 0.85574
## Home_TeamGETAFE -2.246e-14 2.776e-14 -8.090e-01 0.41850
## Home_TeamGIJÓN -2.376e-14 3.583e-14 -6.630e-01 0.50736
## Home_TeamGIRONA 5.732e-15 3.523e-14 1.630e-01 0.87079
## Home_TeamGRANADA -6.143e-15 2.892e-14 -2.120e-01 0.83181
## Home_TeamHUESCA 3.974e-15 4.529e-14 8.800e-02 0.93008
## Home_TeamLAS PALMAS -1.534e-14 3.301e-14 -4.650e-01 0.64207
## Home_TeamLEGANÉS -1.316e-14 2.866e-14 -4.590e-01 0.64628
## Home_TeamLEVANTE -2.566e-14 2.751e-14 -9.330e-01 0.35105
## Home_TeamMÁLAGA 8.515e-14 2.920e-14 2.916e+00 0.00358 **
## Home_TeamMALLORCA -1.205e-14 4.546e-14 -2.650e-01 0.79101
## Home_TeamOSASUNA -1.714e-14 3.543e-14 -4.840e-01 0.62855
## Home_TeamRAYO VALLECANO -2.052e-14 3.212e-14 -6.390e-01 0.52296
## Home_TeamREAL BETIS -1.883e-14 2.844e-14 -6.620e-01 0.50804
## Home_TeamREAL MADRID -2.790e-14 2.977e-14 -9.370e-01 0.34884
## Home_TeamREAL SOCIEDAD -1.570e-14 2.716e-14 -5.780e-01 0.56320
## Home_TeamSEVILLA FC -9.330e-15 2.757e-14 -3.380e-01 0.73509
## Home_TeamVALENCIA -1.069e-14 2.706e-14 -3.950e-01 0.69269
## Home_TeamVALLADOLID -9.416e-15 3.546e-14 -2.660e-01 0.79062
## Home_TeamVILLARREAL -1.324e-14 2.708e-14 -4.890e-01 0.62508
## Away_TeamALMERÍA 7.144e-15 4.605e-14 1.550e-01 0.87672
## Away_TeamATHLETIC 6.895e-14 2.666e-14 2.586e+00 0.00976 **
## Away_TeamATLETICO MADRID -8.674e-15 2.697e-14 -3.220e-01 0.74777
## Away_TeamBARCELONA -1.308e-14 3.145e-14 -4.160e-01 0.67745
## Away_TeamCELTA -4.419e-15 2.709e-14 -1.630e-01 0.87045
## Away_TeamCÓRDOBA -1.860e-14 4.607e-14 -4.040e-01 0.68653
## Away_TeamDEPORTIVO -8.812e-16 2.935e-14 -3.000e-02 0.97605
## Away_TeamEIBAR -1.320e-14 2.692e-14 -4.900e-01 0.62386
## Away_TeamELCHE -2.374e-14 4.606e-14 -5.150e-01 0.60632
## Away_TeamESPANYOL -3.244e-15 2.635e-14 -1.230e-01 0.90201
## Away_TeamGETAFE -8.175e-15 2.770e-14 -2.950e-01 0.76797
## Away_TeamGIJÓN 6.303e-15 3.552e-14 1.770e-01 0.85915
## Away_TeamGIRONA -5.516e-15 3.519e-14 -1.570e-01 0.87543
## Away_TeamGRANADA -1.026e-14 2.891e-14 -3.550e-01 0.72278
## Away_TeamHUESCA 1.033e-15 4.506e-14 2.300e-02 0.98172
## Away_TeamLAS PALMAS -4.880e-15 3.248e-14 -1.500e-01 0.88056
## Away_TeamLEGANÉS -5.360e-15 2.865e-14 -1.870e-01 0.85162
## Away_TeamLEVANTE -9.317e-15 2.733e-14 -3.410e-01 0.73320
## Away_TeamMÁLAGA -7.351e-16 2.924e-14 -2.500e-02 0.97994
## Away_TeamMALLORCA 9.031e-15 4.541e-14 1.990e-01 0.84236
## Away_TeamOSASUNA -2.775e-15 3.512e-14 -7.900e-02 0.93703
## Away_TeamRAYO VALLECANO -8.693e-15 3.215e-14 -2.700e-01 0.78691
## Away_TeamREAL BETIS -1.095e-14 2.840e-14 -3.860e-01 0.69977
## Away_TeamREAL MADRID 9.321e-15 2.932e-14 3.180e-01 0.75061
## Away_TeamREAL SOCIEDAD 1.415e-15 2.706e-14 5.200e-02 0.95831
## Away_TeamSEVILLA FC -3.217e-15 2.707e-14 -1.190e-01 0.90541
## Away_TeamVALENCIA 1.320e-14 2.690e-14 4.910e-01 0.62379
## Away_TeamVALLADOLID 7.821e-15 3.522e-14 2.220e-01 0.82429
## Away_TeamVILLARREAL -3.457e-15 2.688e-14 -1.290e-01 0.89767
## `Home_Team_Possession_%` 1.887e-15 1.366e-15 1.382e+00 0.16719
## `Away_Team_Possession_%` NA NA NA NA
## Home_Team_Off_Target_Shots -1.500e-15 2.065e-14 -7.300e-02 0.94210
## Home_Team_On_Target_Shots -2.531e-15 2.065e-14 -1.230e-01 0.90246
## Home_Team_Total_Shots 8.683e-16 2.056e-14 4.200e-02 0.96632
## Home_Team_Blocked_Shots 1.490e-15 2.059e-14 7.200e-02 0.94229
## Home_Team_Corners -1.493e-16 1.698e-15 -8.800e-02 0.92994
## Home_Team_Throw_Ins -1.454e-15 7.421e-16 -1.960e+00 0.05014 .
## `Home_Team_Pass_Success_%` -3.372e-15 1.454e-15 -2.318e+00 0.02052 *
## Home_Team_Aerials_Won -9.033e-17 7.726e-16 -1.170e-01 0.90693
## Home_Team_Clearances -8.960e-16 6.581e-16 -1.362e+00 0.17347
## Home_Team_Fouls 1.000e+00 1.081e-15 9.248e+14 < 2e-16 ***
## Home_Team_Yellow_Cards 1.551e-15 2.775e-15 5.590e-01 0.57628
## Home_Team_Second_Yellow_Cards 1.594e-15 1.583e-14 1.010e-01 0.91980
## Home_Team_Red_Cards 1.545e-13 1.717e-14 8.996e+00 < 2e-16 ***
## Away_Team_Off_Target_Shots -4.290e-15 1.773e-14 -2.420e-01 0.80885
## Away_Team_On_Target_Shots -3.038e-16 1.780e-14 -1.700e-02 0.98639
## Away_Team_Total_Shots 3.031e-15 1.767e-14 1.720e-01 0.86384
## Away_Team_Blocked_Shots -4.008e-15 1.781e-14 -2.250e-01 0.82199
## Away_Team_Corners -6.562e-16 1.858e-15 -3.530e-01 0.72397
## Away_Team_Throw_Ins -4.620e-16 7.933e-16 -5.820e-01 0.56041
## `Away_Team_Pass_Success_%` 1.370e-15 1.355e-15 1.011e+00 0.31219
## Away_Team_Aerials_Won 1.273e-17 7.633e-16 1.700e-02 0.98669
## Away_Team_Clearances -4.490e-16 6.057e-16 -7.410e-01 0.45857
## Away_Team_Fouls 1.000e+00 1.069e-15 9.352e+14 < 2e-16 ***
## Away_Team_Yellow_Cards 2.631e-16 2.822e-15 9.300e-02 0.92572
## Away_Team_Second_Yellow_Cards -3.285e-15 1.366e-14 -2.400e-01 0.81002
## Away_Team_Red_Cards -1.634e-14 1.682e-14 -9.710e-01 0.33149
## Home_Team_Goals_Scored -4.073e-15 4.858e-15 -8.380e-01 0.40189
## Away_Team_Goals_Scored -3.635e-15 5.489e-15 -6.620e-01 0.50790
## year 1.008e-12 4.996e-13 2.018e+00 0.04369 *
## scorex -2.001e-14 1.220e-14 -1.640e+00 0.10106
## score2 -3.153e-14 1.731e-14 -1.821e+00 0.06869 .
## goals NA NA NA NA
## home_points NA NA NA NA
## away_points NA NA NA NA
## jornada 2.605e-14 1.315e-14 1.981e+00 0.04773 *
## total_off_target_shots NA NA NA NA
## total_on_target_shots NA NA NA NA
## total_shots NA NA NA NA
## total_blocked_shots NA NA NA NA
## total_corners NA NA NA NA
## total_throw_ins NA NA NA NA
## total_pass_success NA NA NA NA
## total_aerials_won NA NA NA NA
## total_clearances NA NA NA NA
## total_yellow_cards NA NA NA NA
## total_second_yellow_cards NA NA NA NA
## total_red_cards NA NA NA NA
## ---
## Signif. codes: 0 '***' 0.001 '**' 0.01 '*' 0.05 '.' 0.1 ' ' 1
##
## Residual standard error: 1.743e-13 on 2187 degrees of freedom
## Multiple R-squared: 1, Adjusted R-squared: 1
## F-statistic: 2.84e+28 on 92 and 2187 DF, p-value: < 2.2e-16lm_amarillas <- lm(total_yellow_cards~., data = train)
summary(lm_amarillas)##
## Call:
## lm(formula = total_yellow_cards ~ ., data = train)
##
## Residuals:
## Min 1Q Median 3Q Max
## -3.378e-12 -9.500e-15 -2.300e-15 5.500e-15 1.379e-13
##
## Coefficients: (16 not defined because of singularities)
## Estimate Std. Error t value Pr(>|t|)
## (Intercept) 9.795e-10 4.328e-10 2.263e+00 0.02373 *
## ...1 1.286e-15 5.655e-16 2.275e+00 0.02301 *
## Home_TeamALMERÍA 1.301e-15 1.982e-14 6.600e-02 0.94767
## Home_TeamATHLETIC -7.515e-16 1.146e-14 -6.600e-02 0.94771
## Home_TeamATLETICO MADRID 3.251e-15 1.159e-14 2.800e-01 0.77919
## Home_TeamBARCELONA 6.030e-15 1.347e-14 4.480e-01 0.65448
## Home_TeamCELTA 3.854e-15 1.180e-14 3.270e-01 0.74405
## Home_TeamCÓRDOBA 7.879e-16 1.984e-14 4.000e-02 0.96832
## Home_TeamDEPORTIVO 2.029e-15 1.259e-14 1.610e-01 0.87194
## Home_TeamEIBAR -1.122e-15 1.168e-14 -9.600e-02 0.92348
## Home_TeamELCHE 7.758e-15 1.988e-14 3.900e-01 0.69638
## Home_TeamESPANYOL -5.897e-17 1.134e-14 -5.000e-03 0.99585
## Home_TeamGETAFE 3.458e-15 1.194e-14 2.900e-01 0.77214
## Home_TeamGIJÓN 9.729e-15 1.541e-14 6.310e-01 0.52800
## Home_TeamGIRONA -3.542e-15 1.516e-14 -2.340e-01 0.81523
## Home_TeamGRANADA 1.389e-15 1.244e-14 1.120e-01 0.91110
## Home_TeamHUESCA -7.080e-15 1.948e-14 -3.630e-01 0.71636
## Home_TeamLAS PALMAS 3.694e-16 1.420e-14 2.600e-02 0.97925
## Home_TeamLEGANÉS 2.749e-15 1.233e-14 2.230e-01 0.82357
## Home_TeamLEVANTE 4.085e-15 1.183e-14 3.450e-01 0.72999
## Home_TeamMÁLAGA -3.942e-14 1.256e-14 -3.138e+00 0.00172 **
## Home_TeamMALLORCA -7.127e-16 1.955e-14 -3.600e-02 0.97093
## Home_TeamOSASUNA -1.124e-15 1.524e-14 -7.400e-02 0.94123
## Home_TeamRAYO VALLECANO 3.938e-15 1.382e-14 2.850e-01 0.77563
## Home_TeamREAL BETIS 4.570e-15 1.223e-14 3.740e-01 0.70877
## Home_TeamREAL MADRID 1.229e-14 1.281e-14 9.600e-01 0.33722
## Home_TeamREAL SOCIEDAD 4.884e-17 1.168e-14 4.000e-03 0.99666
## Home_TeamSEVILLA FC 2.286e-15 1.186e-14 1.930e-01 0.84718
## Home_TeamVALENCIA 4.268e-15 1.164e-14 3.670e-01 0.71389
## Home_TeamVALLADOLID -5.953e-15 1.525e-14 -3.900e-01 0.69637
## Home_TeamVILLARREAL 4.532e-15 1.165e-14 3.890e-01 0.69733
## Away_TeamALMERÍA -3.538e-15 1.981e-14 -1.790e-01 0.85824
## Away_TeamATHLETIC -3.177e-14 1.147e-14 -2.771e+00 0.00564 **
## Away_TeamATLETICO MADRID -8.686e-16 1.160e-14 -7.500e-02 0.94033
## Away_TeamBARCELONA 1.005e-14 1.353e-14 7.420e-01 0.45787
## Away_TeamCELTA 4.682e-16 1.165e-14 4.000e-02 0.96796
## Away_TeamCÓRDOBA 6.019e-15 1.982e-14 3.040e-01 0.76139
## Away_TeamDEPORTIVO -7.317e-16 1.263e-14 -5.800e-02 0.95379
## Away_TeamEIBAR -3.252e-15 1.158e-14 -2.810e-01 0.77884
## Away_TeamELCHE 1.286e-14 1.981e-14 6.490e-01 0.51622
## Away_TeamESPANYOL 3.095e-15 1.133e-14 2.730e-01 0.78480
## Away_TeamGETAFE -2.544e-15 1.192e-14 -2.130e-01 0.83098
## Away_TeamGIJÓN -2.544e-15 1.528e-14 -1.670e-01 0.86774
## Away_TeamGIRONA 2.754e-15 1.514e-14 1.820e-01 0.85565
## Away_TeamGRANADA 2.812e-15 1.244e-14 2.260e-01 0.82118
## Away_TeamHUESCA -4.211e-15 1.938e-14 -2.170e-01 0.82801
## Away_TeamLAS PALMAS 8.474e-15 1.397e-14 6.070e-01 0.54422
## Away_TeamLEGANÉS -1.698e-15 1.233e-14 -1.380e-01 0.89047
## Away_TeamLEVANTE 6.854e-16 1.176e-14 5.800e-02 0.95351
## Away_TeamMÁLAGA -2.307e-16 1.258e-14 -1.800e-02 0.98537
## Away_TeamMALLORCA 1.503e-15 1.953e-14 7.700e-02 0.93866
## Away_TeamOSASUNA -4.290e-15 1.511e-14 -2.840e-01 0.77647
## Away_TeamRAYO VALLECANO 3.420e-15 1.383e-14 2.470e-01 0.80474
## Away_TeamREAL BETIS 8.013e-15 1.222e-14 6.560e-01 0.51200
## Away_TeamREAL MADRID 1.977e-15 1.261e-14 1.570e-01 0.87546
## Away_TeamREAL SOCIEDAD -1.587e-15 1.164e-14 -1.360e-01 0.89160
## Away_TeamSEVILLA FC 2.325e-15 1.165e-14 2.000e-01 0.84179
## Away_TeamVALENCIA 2.787e-15 1.157e-14 2.410e-01 0.80972
## Away_TeamVALLADOLID 3.643e-15 1.515e-14 2.400e-01 0.81001
## Away_TeamVILLARREAL 1.259e-16 1.156e-14 1.100e-02 0.99132
## `Home_Team_Possession_%` -5.458e-16 5.874e-16 -9.290e-01 0.35287
## `Away_Team_Possession_%` NA NA NA NA
## Home_Team_Off_Target_Shots 5.194e-16 8.881e-15 5.800e-02 0.95337
## Home_Team_On_Target_Shots 1.182e-15 8.882e-15 1.330e-01 0.89412
## Home_Team_Total_Shots -8.296e-16 8.844e-15 -9.400e-02 0.92528
## Home_Team_Blocked_Shots -6.959e-17 8.856e-15 -8.000e-03 0.99373
## Home_Team_Corners 4.995e-17 7.303e-16 6.800e-02 0.94547
## Home_Team_Throw_Ins 4.980e-16 3.192e-16 1.560e+00 0.11889
## `Home_Team_Pass_Success_%` 5.894e-16 6.257e-16 9.420e-01 0.34632
## Home_Team_Aerials_Won 3.245e-17 3.323e-16 9.800e-02 0.92223
## Home_Team_Clearances 3.430e-16 2.831e-16 1.212e+00 0.22576
## Home_Team_Fouls 1.636e-16 4.651e-16 3.520e-01 0.72509
## Home_Team_Yellow_Cards 1.000e+00 1.194e-15 8.377e+14 < 2e-16 ***
## Home_Team_Second_Yellow_Cards 8.731e-17 6.811e-15 1.300e-02 0.98977
## Home_Team_Red_Cards -6.648e-14 7.388e-15 -8.999e+00 < 2e-16 ***
## Away_Team_Off_Target_Shots 7.694e-16 7.627e-15 1.010e-01 0.91966
## Away_Team_On_Target_Shots -7.360e-16 7.659e-15 -9.600e-02 0.92345
## Away_Team_Total_Shots -1.148e-16 7.601e-15 -1.500e-02 0.98795
## Away_Team_Blocked_Shots 5.295e-16 7.662e-15 6.900e-02 0.94491
## Away_Team_Corners 3.664e-16 7.991e-16 4.580e-01 0.64669
## Away_Team_Throw_Ins 1.768e-16 3.413e-16 5.180e-01 0.60436
## `Away_Team_Pass_Success_%` -7.188e-16 5.828e-16 -1.233e+00 0.21761
## Away_Team_Aerials_Won -1.078e-17 3.283e-16 -3.300e-02 0.97382
## Away_Team_Clearances 1.967e-16 2.606e-16 7.550e-01 0.45027
## Away_Team_Fouls 4.396e-16 4.600e-16 9.560e-01 0.33936
## Away_Team_Yellow_Cards 1.000e+00 1.214e-15 8.238e+14 < 2e-16 ***
## Away_Team_Second_Yellow_Cards 2.385e-15 5.877e-15 4.060e-01 0.68491
## Away_Team_Red_Cards 6.626e-15 7.237e-15 9.160e-01 0.35995
## Home_Team_Goals_Scored 1.783e-15 2.090e-15 8.530e-01 0.39370
## Away_Team_Goals_Scored 1.707e-15 2.361e-15 7.230e-01 0.46978
## year -4.864e-13 2.149e-13 -2.263e+00 0.02372 *
## scorex 8.315e-15 5.247e-15 1.585e+00 0.11312
## score2 1.172e-14 7.447e-15 1.574e+00 0.11573
## goals NA NA NA NA
## home_points NA NA NA NA
## away_points NA NA NA NA
## jornada -1.258e-14 5.656e-15 -2.224e+00 0.02628 *
## total_off_target_shots NA NA NA NA
## total_on_target_shots NA NA NA NA
## total_shots NA NA NA NA
## total_blocked_shots NA NA NA NA
## total_corners NA NA NA NA
## total_throw_ins NA NA NA NA
## total_pass_success NA NA NA NA
## total_aerials_won NA NA NA NA
## total_clearances NA NA NA NA
## total_fouls NA NA NA NA
## total_second_yellow_cards NA NA NA NA
## total_red_cards NA NA NA NA
## ---
## Signif. codes: 0 '***' 0.001 '**' 0.01 '*' 0.05 '.' 0.1 ' ' 1
##
## Residual standard error: 7.497e-14 on 2187 degrees of freedom
## Multiple R-squared: 1, Adjusted R-squared: 1
## F-statistic: 2.286e+28 on 92 and 2187 DF, p-value: < 2.2e-16lm_rojas <- lm(total_red_cards~., data = train)
summary(lm_rojas)##
## Call:
## lm(formula = total_red_cards ~ ., data = train)
##
## Residuals:
## Min 1Q Median 3Q Max
## -3.830e-14 -1.270e-16 -1.900e-17 9.900e-17 7.668e-15
##
## Coefficients: (16 not defined because of singularities)
## Estimate Std. Error t value Pr(>|t|)
## (Intercept) 1.363e-11 5.190e-12 2.626e+00 0.008689 **
## ...1 1.794e-17 6.781e-18 2.646e+00 0.008204 **
## Home_TeamALMERÍA 1.421e-17 2.377e-16 6.000e-02 0.952326
## Home_TeamATHLETIC -6.885e-18 1.374e-16 -5.000e-02 0.960039
## Home_TeamATLETICO MADRID 1.300e-16 1.390e-16 9.350e-01 0.349748
## Home_TeamBARCELONA 4.289e-16 1.616e-16 2.655e+00 0.007996 **
## Home_TeamCELTA 2.524e-18 1.415e-16 1.800e-02 0.985771
## Home_TeamCÓRDOBA 2.055e-16 2.379e-16 8.640e-01 0.387801
## Home_TeamDEPORTIVO -1.546e-16 1.509e-16 -1.024e+00 0.305895
## Home_TeamEIBAR -2.960e-16 1.401e-16 -2.113e+00 0.034698 *
## Home_TeamELCHE -9.340e-17 2.384e-16 -3.920e-01 0.695255
## Home_TeamESPANYOL -1.095e-16 1.360e-16 -8.050e-01 0.420694
## Home_TeamGETAFE -2.765e-17 1.432e-16 -1.930e-01 0.846907
## Home_TeamGIJÓN -6.294e-17 1.848e-16 -3.400e-01 0.733518
## Home_TeamGIRONA -1.129e-16 1.818e-16 -6.210e-01 0.534692
## Home_TeamGRANADA -1.694e-16 1.492e-16 -1.135e+00 0.256421
## Home_TeamHUESCA -2.120e-16 2.336e-16 -9.070e-01 0.364271
## Home_TeamLAS PALMAS 2.898e-17 1.703e-16 1.700e-01 0.864861
## Home_TeamLEGANÉS 4.467e-17 1.478e-16 3.020e-01 0.762576
## Home_TeamLEVANTE 7.530e-18 1.419e-16 5.300e-02 0.957688
## Home_TeamMÁLAGA -6.149e-16 1.506e-16 -4.082e+00 4.62e-05 ***
## Home_TeamMALLORCA -5.799e-16 2.345e-16 -2.473e+00 0.013474 *
## Home_TeamOSASUNA -3.582e-17 1.828e-16 -1.960e-01 0.844634
## Home_TeamRAYO VALLECANO 3.713e-17 1.657e-16 2.240e-01 0.822667
## Home_TeamREAL BETIS -2.032e-17 1.467e-16 -1.390e-01 0.889835
## Home_TeamREAL MADRID -1.111e-17 1.536e-16 -7.200e-02 0.942319
## Home_TeamREAL SOCIEDAD 3.759e-17 1.401e-16 2.680e-01 0.788459
## Home_TeamSEVILLA FC 5.898e-17 1.422e-16 4.150e-01 0.678401
## Home_TeamVALENCIA 6.072e-17 1.396e-16 4.350e-01 0.663584
## Home_TeamVALLADOLID -2.441e-16 1.829e-16 -1.335e+00 0.182136
## Home_TeamVILLARREAL -4.508e-18 1.397e-16 -3.200e-02 0.974264
## Away_TeamALMERÍA 3.662e-16 2.375e-16 1.542e+00 0.123295
## Away_TeamATHLETIC 3.890e-17 1.375e-16 2.830e-01 0.777303
## Away_TeamATLETICO MADRID 3.891e-16 1.391e-16 2.797e+00 0.005208 **
## Away_TeamBARCELONA 2.739e-16 1.622e-16 1.688e+00 0.091534 .
## Away_TeamCELTA 2.870e-16 1.398e-16 2.054e+00 0.040139 *
## Away_TeamCÓRDOBA 5.004e-16 2.377e-16 2.105e+00 0.035366 *
## Away_TeamDEPORTIVO 1.623e-16 1.514e-16 1.072e+00 0.283886
## Away_TeamEIBAR 1.251e-16 1.388e-16 9.010e-01 0.367500
## Away_TeamELCHE 9.939e-16 2.376e-16 4.183e+00 2.99e-05 ***
## Away_TeamESPANYOL 2.108e-16 1.359e-16 1.551e+00 0.120984
## Away_TeamGETAFE 2.790e-16 1.429e-16 1.952e+00 0.051026 .
## Away_TeamGIJÓN 5.070e-16 1.832e-16 2.767e+00 0.005698 **
## Away_TeamGIRONA 2.426e-16 1.815e-16 1.336e+00 0.181548
## Away_TeamGRANADA 3.596e-16 1.492e-16 2.411e+00 0.015986 *
## Away_TeamHUESCA 1.213e-16 2.324e-16 5.220e-01 0.601884
## Away_TeamLAS PALMAS 3.123e-16 1.675e-16 1.864e+00 0.062431 .
## Away_TeamLEGANÉS 3.064e-16 1.478e-16 2.073e+00 0.038298 *
## Away_TeamLEVANTE 2.529e-16 1.410e-16 1.794e+00 0.072944 .
## Away_TeamMÁLAGA 2.348e-16 1.508e-16 1.557e+00 0.119669
## Away_TeamMALLORCA 3.322e-16 2.342e-16 1.418e+00 0.156207
## Away_TeamOSASUNA 2.864e-16 1.812e-16 1.581e+00 0.114038
## Away_TeamRAYO VALLECANO 3.710e-16 1.658e-16 2.237e+00 0.025387 *
## Away_TeamREAL BETIS 3.955e-16 1.465e-16 2.700e+00 0.006993 **
## Away_TeamREAL MADRID 1.712e-16 1.513e-16 1.132e+00 0.257881
## Away_TeamREAL SOCIEDAD 2.628e-16 1.396e-16 1.882e+00 0.059906 .
## Away_TeamSEVILLA FC 3.274e-16 1.396e-16 2.344e+00 0.019142 *
## Away_TeamVALENCIA 1.758e-16 1.388e-16 1.267e+00 0.205292
## Away_TeamVALLADOLID 1.609e-16 1.817e-16 8.850e-01 0.376020
## Away_TeamVILLARREAL 2.999e-16 1.387e-16 2.163e+00 0.030645 *
## `Home_Team_Possession_%` -3.858e-18 7.044e-18 -5.480e-01 0.583990
## `Away_Team_Possession_%` NA NA NA NA
## Home_Team_Off_Target_Shots -3.205e-16 1.065e-16 -3.010e+00 0.002647 **
## Home_Team_On_Target_Shots -3.548e-16 1.065e-16 -3.331e+00 0.000879 ***
## Home_Team_Total_Shots 3.507e-16 1.061e-16 3.307e+00 0.000959 ***
## Home_Team_Blocked_Shots -3.625e-16 1.062e-16 -3.413e+00 0.000655 ***
## Home_Team_Corners 9.020e-18 8.757e-18 1.030e+00 0.303160
## Home_Team_Throw_Ins -7.873e-19 3.828e-18 -2.060e-01 0.837064
## `Home_Team_Pass_Success_%` 1.018e-18 7.503e-18 1.360e-01 0.892067
## Home_Team_Aerials_Won -1.118e-17 3.985e-18 -2.805e+00 0.005073 **
## Home_Team_Clearances 2.001e-18 3.394e-18 5.890e-01 0.555687
## Home_Team_Fouls 4.558e-18 5.578e-18 8.170e-01 0.413915
## Home_Team_Yellow_Cards -5.983e-18 1.431e-17 -4.180e-01 0.676030
## Home_Team_Second_Yellow_Cards -2.996e-17 8.168e-17 -3.670e-01 0.713800
## Home_Team_Red_Cards 1.000e+00 8.859e-17 1.129e+16 < 2e-16 ***
## Away_Team_Off_Target_Shots 1.254e-17 9.146e-17 1.370e-01 0.890968
## Away_Team_On_Target_Shots -5.487e-18 9.184e-17 -6.000e-02 0.952368
## Away_Team_Total_Shots -7.730e-18 9.115e-17 -8.500e-02 0.932429
## Away_Team_Blocked_Shots 9.257e-18 9.188e-17 1.010e-01 0.919760
## Away_Team_Corners 1.062e-17 9.583e-18 1.108e+00 0.268105
## Away_Team_Throw_Ins -1.340e-18 4.092e-18 -3.270e-01 0.743402
## `Away_Team_Pass_Success_%` -5.331e-18 6.989e-18 -7.630e-01 0.445699
## Away_Team_Aerials_Won 5.097e-18 3.937e-18 1.295e+00 0.195608
## Away_Team_Clearances -4.626e-19 3.125e-18 -1.480e-01 0.882325
## Away_Team_Fouls 5.493e-18 5.516e-18 9.960e-01 0.319424
## Away_Team_Yellow_Cards 1.034e-17 1.456e-17 7.100e-01 0.477659
## Away_Team_Second_Yellow_Cards 8.658e-18 7.048e-17 1.230e-01 0.902243
## Away_Team_Red_Cards 1.000e+00 8.678e-17 1.152e+16 < 2e-16 ***
## Home_Team_Goals_Scored 3.031e-17 2.506e-17 1.210e+00 0.226595
## Away_Team_Goals_Scored 1.040e-17 2.831e-17 3.670e-01 0.713442
## year -6.769e-15 2.577e-15 -2.627e+00 0.008684 **
## scorex 1.086e-16 6.291e-17 1.726e+00 0.084484 .
## score2 1.580e-16 8.930e-17 1.770e+00 0.076931 .
## goals NA NA NA NA
## home_points NA NA NA NA
## away_points NA NA NA NA
## jornada -1.768e-16 6.783e-17 -2.607e+00 0.009189 **
## total_off_target_shots NA NA NA NA
## total_on_target_shots NA NA NA NA
## total_shots NA NA NA NA
## total_blocked_shots NA NA NA NA
## total_corners NA NA NA NA
## total_throw_ins NA NA NA NA
## total_pass_success NA NA NA NA
## total_aerials_won NA NA NA NA
## total_clearances NA NA NA NA
## total_fouls NA NA NA NA
## total_yellow_cards NA NA NA NA
## total_second_yellow_cards NA NA NA NA
## ---
## Signif. codes: 0 '***' 0.001 '**' 0.01 '*' 0.05 '.' 0.1 ' ' 1
##
## Residual standard error: 8.99e-16 on 2187 degrees of freedom
## Multiple R-squared: 1, Adjusted R-squared: 1
## F-statistic: 3.238e+30 on 92 and 2187 DF, p-value: < 2.2e-16
5.1 REGRESION BACKWARD STEPWISE
5.2 REGRESION FORWARD STEPWISE
6 CONCLUSIONES
Hay muchas variables que no afectan al resultado de un partido.
Los equipos locales ganan más.
Hay dos equipos que sobresalen (Madrid y Barsa)
Hay un grupo de equipos “buenos” (nunca han descendido, meten más
goles…)
De cara al futuro:
Cuanto se parecen dos partidos?
Clusterizar equipos en buenos, medios y malos.
Incluir las rachas de victorias, dorrotas y empates.
Calcular los puntos que suma cada equipo por partido en función de ser
local o visitante, del “nivel” del rival, etc.
Predecir el número de goles que va a marcar cada equipo en un partido,
en vez de victoria/derrota/empate.